Friday, June 20, 2008

Single quote in sql

USE Northwind

SELECT CHAR(39)+ CompanyName FROM Customers

SELECT a='Thailand''s', b='Thailand'+'''s'

No comments:

Post a Comment