importing data into sql server which contains delimters

Soldato
Joined
18 Oct 2002
Posts
6,795
Hi guys,

I'm having trouble importing a field into SQL server because some of the data has a leading character of a square bracket "[". Is there anyway i can pull this information through without stripping it of the leading "["?

IE:

insert into table_abc (column_a) select fieldwhichcontainsirritatingcharacter from sourcetable

B@
 
Back
Top Bottom