Home Forums SQL Server 2008 T-SQL (SS2K8) Manipulate String RE: Manipulate String

  • December 22, 2010 at 2:22 pm

    #1265702

    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!