Posted by Martin Lukasik on 04/24/06 18:37

Hi,

I'm not a big friend of MSSQL, but I have to do one query I've done for
mySQL.
But I don't know how...

I have to select 'user' from 'db' where first letter is E or N, second is B
or 0 and after that there are 6 or 7 digits I know.
How can I do that?

In mySQL it would be something like:

SELECT * FROM `table` WHERE `account` regexp '^[EN][B0]123456$' ORDER BY
`Id`;


Thanks in advance,
Martin

• Next in forum: Re: SELECT and regular expression
• Prev in forum: Re: Exporting sql data to specific cells
• Thread view: SELECT and regular expression

[Reply to this message]