LTRIM on an ntext field

[edwardturner]

Hi,

i am trying to strip out all the whitespace on the left hand side of a field which set to ntext. I assume I have to cast or convert this field to a different format but am unsure what. Any ideas?

update <table>
set <field> = ltrim(<field>)

 

[mrdenny]

Convert it to NVARCHAR(4000), you will only get the first 4000 characters of the field however.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[edwardturner]

Cool, that works. Thank you.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com