Searching for a carriage return in a text field

[levinll]

Somehow a user was able to enter a CR/LF into a text field in one of my tables. I'd like to be able to search the rest of the records to see if this has happened before, but I'm not sure of the syntax I'd have to use. Can anyone enlighten me ?

Also does anyone have any idea on how to prevent a CR/LF from being inserted into a database ? I'm using VB as a front end/SQL Server as the back end.

 

[rac2]

In T-SQL, CHAR(10) is a new line, CHAR(13) is a carriage return. Maybe

SELECT * FROM myTable WHERE PATINDEX(CHAR(10), myTextField) > 0

In VB, you might use the String.Replace method to replace these characters with nothing. I don't know VB so this is just an idea.