I have a EUW0 field 10598260, and needed to be EUW 1598260
I need to remove a specific field
SQL:
SELECT 'EUW' + substring(campo,patindex('%[^EUW0 ]%',campo + ' ')
,len(campo)) AS campo1
,campo2
FROM [tabela]
WHERE campo3 = 'cp'
AND campo LIKE '%EUW0%'