Re: DTS script question

[Randy Vaughn]

could you possibly use an update query with a WHERE clause that searches the first name field with charindex() function.

update table
set firstname = left(firstname,charindex(chr(32),firstname,1)-1)&mid(firstname,charindex(chr(32),firstname,1)+1,30)
where charindex(chr(32),firstname,1)>0

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---