Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hbothner
Starting Member
1 Post |
 Posted - 2011-02-22 : 14:10:22
|
| With a field type of LONG I want to select the field if there is a hard return somewhere in the field. I assume I will be using LIKE, but not sure how to put the argrument value. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-22 : 14:15:35
|
| SELECT * FROM myTable WHERE col1 LIKE '%' + CHAR(13) + CHAR(10) + '%'Above syntax assumes SQL Server and Windows line feeds (CR-LF). SQL Server has text and varchar(max) but not LONG data types, if you're not using SQL Server you may need to adjust syntax or look on website that supports your RDBMS platform. |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2011-02-23 : 03:48:01
|
| Looks like Oracle. The query above should work.MirkoMy blog: http://mirko-marovic-eng.blogspot.com/ |
|
|
|
|
|
|
How to find Hard Returns