1)
DECLARE @NewLine char(2)
SET @NewLine=char(13)+char(10)
SELECT *
FROM TABLENAME
WHERE CHARINDEX(@NewLine,ColumnName) > 0
2)
DECLARE @NewLine char(2)
SET @NewLine=char(13)
SELECT *
FROM TABLENAME
WHERE CHARINDEX(@NewLine,ColumnName) > 0
3)
DECLARE @NewLine char(2)
SET @NewLine=char(10)
SELECT *
FROM TABLENAME
WHERE CHARINDEX(@NewLine,ColumnName) > 0
3 comments:
1st one is appropraite to remove a new line char from string. As with new line char, it bring both Line feed(LF) and carriage return(CR).
Thank you so much.. appreciate!..
Awesome Post!! Thanks much!!!
Post a Comment