how to remove leading tab from string

[ashok2006]

Hi everybody.
I'm reading a file in storing its contents in a temprory table.
Now in a stored procedure i reading this table's record for further procecessing and parsing the read lines. To remove all not-printable character i have used following functions

RTrim(LTrim(" String "))

but the problem is that it is not removing leading tab character in the string.
Can anybody suggest any workaround.

[Ahmet Ozgur]

Hi,
Try this:

SELECT REPLACE(column1 ,CHAR(9),'')