?
Solved

Add Prefix to Query - SQL 2005

Posted on 2009-04-15
2
Medium Priority
?
589 Views
Last Modified: 2013-11-10
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

select ts_issueid
from ttt_items
where ts_issuetype = 1090

Open in new window

0
Comment
Question by:johngabrielson2008
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 24152134
simple
select 'WWW' + ts_issueid
from ttt_items
where ts_issuetype = 1090

Open in new window

0
 
LVL 1

Author Closing Comment

by:johngabrielson2008
ID: 31570691
That it was...
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question