SQL 2005 String Functions
Posted on 2008-10-31
I need to detect the presence of linefeed/new line characters in a string I'm parsing in SQL 2005.
The string is of the format ~1000~3483923~893493~...~A~Temp~End
The elements are split by the delimiter and inserted in a table. Sometimes, the string contains newline characters in the middle of numbers which SQL parses and returns as 599.3 233 with a space in between
trying REPLACE(Element,' ','') does not work because SQL still recognises it as a newline and not a space. Does anyone know what is to be specified in the REPLACE function?