mesutd0nmez
6/6/2017 - 1:02 PM

SQL Sağ ve Soldaki verileri silme

SQL Sağ ve Soldaki verileri silme

sql_left_right_remove.sql
content_copyfile_download
SELECT   [FullName]
        ,LEFT([FullName], CHARINDEX(',', [FullName]) - 1) AS [Surname]
        ,REPLACE(SUBSTRING([FullName], CHARINDEX(',', [FullName]), LEN([FullName])), ',', '') AS [FirstName]
FROM    Employee