Posted by Hugo Kornelis on 04/24/06 23:09

On Mon, 24 Apr 2006 16:37:44 +0100, Martin Lukasik wrote:

>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...
(snip)
>In mySQL it would be something like:
>
>SELECT * FROM `table` WHERE `account` regexp '^[EN][B0]123456$' ORDER BY
>`Id`;

Hi Martin,

Try

SELECT * -- Use column list instead!!
FROM table
WHERE account LIKE '[EN][B0]123456%'
ORDER BY Id

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: SELECT and regular expression
• Prev in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Thread view: Re: SELECT and regular expression

[Reply to this message]