I have several value in a column called test.
Select Statement: Select Test From Abc
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?
--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!