Last Post 25 Apr 2002 10:50 AM by LACBA_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

25 Apr 2002 10:50 AM
I'm importing data into a new table, to later export to the target database.
the source data has a field ADDRESS_CODE that has a value of PRIM (VARCHAR) data type, for primary addresses, How can I convert (PRIM) to be 1 and the new field called "AddressID" to be INT data type in the new table?

Acceptable Use Policy