declare @var nvarchar(max)='ST-1' SELECT LEFT(Val,PATINDEX('%[^0-9]%', Val+'a')-1) from( SELECT SUBSTRING(@var, PATINDEX('%[0-9]%', @var), LEN(@var)) Val )x
SELECT right(rtrim(StoreId), LEN(rtrim(StoreId)) - 3) FROM TableName
SELECT substring(StoreId,instr(StoreId,'-'),length(StoreId)) from TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)