Thursday, September 3, 2009

Remove Unwanted strings in a Column while inserting to another table using Select Query

INSERT INTO dbo.EMPLOYEE_MASTER
(
EMPLOYEE_STATE
)
SELECT DISTINCT REPLACE(EMPLOYEE_DETAILS.STATE,'"','') STATE FROM dbo.EMPLOYEE_DETAILS

0 comments:

.