Results 1 to 2 of 2

Thread: Record Select

  1. #1
    Join Date
    Mar 2006
    Posts
    127

    Record Select

    Hi All,

    I have a column in a table that has the data that looks like this:

    1 1234 somewhere street
    2 45a main rd
    3 124A work ave
    4 new street

    I need to pull records 2 and 3 only. Any ideas?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    What is the criteria for selecting records 2 or 3, is it the first character in the column?

    select * from table1
    where substr(col1,1,1) in ('2','3')

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •