Home Forums SQL Server 2005 Working with Oracle Query with variable for "any letter" RE: Query with variable for "any letter"

  • February 17, 2012 at 8:30 am

    #1448563

    both SQL and Oracle support pattern matching for any character:

    select * from YourTable

    where YourColumn like '%H_M%'

    SQL supports a type of regular expression like this:

    select * from YourTable

    where YourColumn like '%H[a,e,i,o,u,A]M%'

    select * from YourTable

    where YourColumn like '%H[^e]M%' --<your example NOT E, but any other letter:

    where Oracle requires you to use the regular expression object to do the same:

    http://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions007.htm

    does that help?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!