Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

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 Team Elevate	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 Team Elevate	Ian OK I admint I forgot the final % Roy Lambert