Add " mark to query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add quotaton mark to each result pulled from a query? We need to
upload the query results (email addresses) to Novell and it requires that
each result have a " mark at the end. I really do not want to manually add
each " tp 6000+ email addresses!
TIA
 
What does the SQL statement for your query look like? Post it and we can
suggest how to do it.
 
Laura said:
How can I add quotaton mark to each result pulled from a query? We need to
upload the query results (email addresses) to Novell and it requires that
each result have a " mark at the end. I really do not want to manually add
each " tp 6000+ email addresses!
TIA
Click to expand...

SELECT email & '"' As email_address
FROM ... etc. ...
 
Back
Top