Hi SQL Champs!
I have a text file source where some data are an question mark (?). Importing this to SQL serever, I want to exchange these (?) with an NULL -value.
How do I do this most easy? Do I need a another tmptable first?
Many thaks
kurlan
While importing this you can use the replace function to replace these values on the fly.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||Rule!
Thanks
No comments:
Post a Comment