Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT Rut,
  2. LEFT(Rut,CHARINDEX('-',Rut)-1) Rut_Sin_DV
  3. FROM dbo.YourTable;
  4.  
  5. SELECT Rut,
  6. CASE
  7. WHEN CHARINDEX('-',Rut) > 0 THEN LEFT(Rut,CHARINDEX('-',Rut)-1) Rut_Sin_DV
  8. ELSE Rut
  9. END Rut_Sin_DV
  10. FROM dbo.YourTable;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement