SQL: Regular Expressions `

I need to have a sql rexeg pattern that matches any number between 42.67 and 42.86

This is what i Have, but I am not sure if its working

42\.[6-9][0-6]

Can anyone help ? Thanks !!

I开发者_开发知识库 am using an analytics program that only accepts sql regex i do not have access to the db to run queries against it.

Try this:

42\.(6[7-9]|7[0-9]|8[0-6])

Why do you need a regex? Just select column from table where column>=42.67 and column<=42.86;