Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
End of line in a CLOB? |
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 |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |