Manipulate String

Question

Manipulate String

JStevenson1

SSC-Addicted

Points: 484
More actions
December 22, 2010 at 1:59 pm

#231004

I have several value in a column called test.
Select Statement: Select Test From Abc
Output: JonDoe
Desired Output: 'JonDoe'
How do I achieve desired output?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

JStevenson1 (12/22/2010)
I have several value in a column called test.
Select Statement: Select Test From Abc
Output: JonDoe
Desired Output: 'JonDoe'
How do I achieve desired output?

so the only difference is you want single quotes around the field, right?

this is pretty straight forward, what have you tried so far?

I hate to give it away in case this is a homework question, so let me give some hints first:

are you familiar with how to concatenate strings together in a select statement?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

JStevenson1 (12/22/2010)
I have several value in a column called test.
Select Statement: Select Test From Abc
Output: JonDoe
Desired Output: 'JonDoe'
How do I achieve desired output?

Are you wanting to add the single quote around the field?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

JINX! I too assumed this to be homework. 😉

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

LutzM SSC Guru Points: 107049 More actions · Answer 4

JStevenson1 (12/22/2010)
I have several value in a column called test.
Select Statement: Select Test From Abc
Output: JonDoe
Desired Output: 'JonDoe'
How do I achieve desired output?

Something like the following code? (assuming all you want to do is add the quotation marks...)

Select ''''+Test +'''' From Abc

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

JStevenson1 SSC-Addicted Points: 484 More actions · Answer 5

JStevenson1

SSC-Addicted

Points: 484

December 22, 2010 at 2:27 pm

#1265708

Worked. Thanks!