Help with a selection query

[aquatsr]

So I have a table called books and I want to select all titles that start with a number (any number), how would I do such a thing?

[murfitUK]

You could try this:SELECT * FROM books WHERE title < 'A'This would give you titles starting with a number - but also blank entries as well.

[aquatsr]

You could try this:SELECT * FROM books WHERE title < 'A'This would give you titles starting with a number - but also blank entries as well.

I'll try that, if it really does work it won't be a problem as I don't have any blank entries (yet).thx.

[bhavik_solanki]

Try this. This will return only records start with number. will not even blank.Select * from Books Where Title like '[0-9]%'

[aquatsr]

Try this. This will return only records start with number. will not even blank.Select * from Books Where Title like '[0-9]%'

Thanks! I'll be sure to try that!