Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-12 : 08:51:09
|
| Robert writes "Hello My Question Is why I can't make this work in SQL Server and it Works ok in access UPDATE table1 SET column1 = column2 + '.gif'Thanks." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-11-12 : 09:05:44
|
quote:
Robert writes "Hello My Question Is why I can't make this work in SQL Server and it Works ok in access UPDATE table1 SET column1 = column2 + '.gif'Thanks."
I don't know. Why can't you make it work? What error message do you get? What's the datatype of column1 and column2? |
 |
|
|
burbakei
Yak Posting Veteran
80 Posts |
Posted - 2002-11-13 : 13:26:58
|
| you can do it easily if the data types of Column1, Column2 arecompatible with char datatype. |
|
|
|
|
|
|
UPDATE