|
kifeda
Posting Yak Master
136 Posts |
 Posted - 01/30/2007 : 12:26:19
|
I have a tabkle that I want to use for NT authnetication. It was a list of domain lan usernames. I want to use NT authentication in ASP but in order to do so I need to add the domain to each of the lan ds. So my username, kssensalo needs to be DOMAIN\kssensalo. I need to do this for 5,000+ plus records. What SQL fucntion would I use? I know I can use LTRIM to remove, but I need to add or append.
Any suggesttions? |
|
How do I add a part to a field?
