i have two varchar fields say
field1 varchar(20)
field2 varchar(4)
i want to return a result in the format field1 - field2
my query tries to add the two fields together
select (field1 + ' - ' + field2) as result from table
any help much appreciated
| CodeGuru Home | VC++ / MFC / C++ | .NET / C# | Visual Basic | VB Forums | Developer.com |
|
Results 1 to 4 of 4
Thread: mySQL queryThreaded View
|
Click Here to Expand Forum to Full Width |