Thread: SQL experts, can you please help.
View Single Post
Old 05-23-2012, 02:13 PM  
Just Alex
Liv Benson to You, Bitch
 
Just Alex's Avatar
 
Industry Role:
Join Date: Aug 2007
Location: Maryland and WV
Posts: 6,060
Quote:
Originally Posted by Brujah View Post
UPDATE table SET File_name = CONCAT( File_id, '.jpg' );
Huh, it worked. Im so stupid adding convert(varchar(100) to this thinking numeric field cant be concatenated in text fields.

Thank you very much!
__________________
Just Alex is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote