![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
![]() |
Fri, Jan 21 2022 10:04 PM | Permanent Link |
Ian Branch | Hi Team,
I have the following test in a sql query - "c.changes like '% to AC%'". My problem is that it will find what I want, plus, things like " to accept". ![]() " to AC" will always be at the end of a line. Is there a way to insert whatever newline character EDB uses into this test and if so, what is the character? Regards & TIA, Ian |
Sat, Jan 22 2022 4:06 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Ian
Its carriage return , line feed so c.changes like '% to AC%'+#13+#10 Roy Lambert |
Sat, Jan 22 2022 3:47 PM | Permanent Link |
Ian Branch | Hi Roy,
Close, but no Cupie Doll on this one.. ![]() it was "(c.changes like '% to AC'+#13+#10+'%')" Thanks for the pointer. Regards, Ian |
Sun, Jan 23 2022 2:19 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Ian
OK I admint I forgot the final % ![]() Roy Lambert |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |