dob ?? 😀

what is the 'dob' of the author of this question ?:hehe:

How about this?

declare @pos smallint

declare @string varchar(100)

set @string = '1109A><":{$%^&*4DSE2@!~$%^&567KJHGT'

while isnumeric(@string+'e0') = 0

begin

set @pos = (select patindex('%[^0-9]%',@string))

set @string = (select replace(@string,substring(@string,@pos,1),''))

end

select @string

there is a reson to add 'e0' to the...