RE: substring – SQLServerCentral

SSC Guru

Points: 323504

August 17, 2010 at 10:40 am

#1208035

ny66 (8/17/2010)
if i use replace, i still cant get the values in the columns i need due to length of the field. there is no set length on the first value it hits.

spaces, tabs and CrLf can make all the difference in the world here....

can you post the example data as an actual INSERT INTO query?(don't paste my example back...that already worked correctly)

what i created could be radically different than the actual data; since the devil is in the details here, without your data for us to test against, we can't help out.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!