.Net Sports
3/29/2007 3:37:00 PM
I need to assign a default for varchar datatype field in my dbase,
where as each time a row is added, an image name for that particular
field is automatically generated. What I need to do is to add the
'category' field name plus concatenate the ID # 'id', a primary key
integer datatype as the 'imagename' for each entry'/row, but having
trouble using CAST (to change the 'id' into a character) to do this, I
am using MyLittle SQL Admin as the management tool.
thanks in advance
NetSports