johngabrielson2008
asked on
Add Prefix to Query - SQL 2005
How to I add a three letter prefix to the query listed below? The column is varchar.
Current Data Return from ts_issueid:
01011
01012
01013
Need:
WWW01011
WWW01012
WWW01013
Current Data Return from ts_issueid:
01011
01012
01013
Need:
WWW01011
WWW01012
WWW01013
select ts_issueid
from ttt_items
where ts_issuetype = 1090
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER