The column is call name that it is in one database and it includes the
lastname and the first name seperated by a coma. I am using a DTS package
to pull this data into my sql server. I want to know how to seperate these
two and put them into two columns: FNAME and LNAME
> -----Original Message-----
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 4:58 PM
> To: CF-Talk
> Subject: Re: seperate data
>
>
> Do you mean that the fname and lname are in the same column?
>
> If they are are you wanting to split these into two seperate columns?
>
> I apologize for asking, but your request is a little vague.
>
> Clint
>
> ---------- Original Message ----------------------------------
> From: "Joshua Tipton" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 01 May 2001 15:47:59 -0400
>
> I have a column in an sql table that has the lname, fname. I want to
> seperate this out in an sql table. What is the code that I can run in dts
> to seperate these two.
>
> Thanks,
>
> Joshua Tipton
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
