/ Published in: SQL

Extrae subcadena de cadena separado por caracter
Expand |
Embed | Plain Text
SELECT CASE WHEN CHARINDEX('(', Val) > 0 THEN RTRIM(SUBSTRING(val,1, CHARINDEX('(', Val) - 1)) ELSE Val END FROM @DATA
You need to login to post a comment.