Posted By

ironcrema on 11/12/13

Tagged

sql
server

Versions (?)

Last Edited at 11/12/13 02:55am

Statistics

Viewed 1685 times

Favorited by 0 user(s)

Related snippets

Extraer cadena segun caracter

/ Published in: SQL

Extrae subcadena de cadena separado por caracter

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT 
    CASE 
        WHEN CHARINDEX('(', Val) > 0 THEN 
            RTRIM(SUBSTRING(val,1, CHARINDEX('(', Val) - 1))
        ELSE Val
    END
FROM @DATA

Report this snippet Tweet

Comments

You need to login to view comments.