Post reply

wild card

  • January 28, 2013 at 2:29 pm

    #269604

    If I want to filter out where companyID has two alpha letters, what is the sysntax:

    Currently the companyID data has values like two digits numbers, one digit with a letter, two letters.

    Select companyID, companyname

    where companyID like ..

    Thanks

  • January 28, 2013 at 3:00 pm

    #1581826

    If your companyID datatype is CHAR(2), it's pretty simple:

    select companyID, companyname

    where companyID like '[a-z][a-z]'

    If it could potentially be longer than two characters and you want to find ones with exactly 2 alpha characters, it could get a little more complicated.

  • January 28, 2013 at 4:47 pm

    #1581849

    Thanks much

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply