how to use Regular Expressions

[ramesh1210]

Hi all,

Actuall there is a field given varchar(100) Now from that i need to get all the fields that contains anything other than numbers
for example:
1.2
1.3
0.0%
demo1.0,

output:
0.0%
demo1.0,
I think its easy to get this by using regular expression,
But i didn't find any material for how to use regular expressions in sql server
Help me in solving this.

[ck9663]

Try:

declare @mytable table (myfield varchar(100))

insert into @mytable values ('1.2')
insert into @mytable values ('1.3')
insert into @mytable values ('0.0%')
insert into @mytable values ('demo1.0')

select * from @mytable
where isnumeric(myfield) = 0

[ramesh1210]

Thanks for giving a simple solution..