Help (select like)

Results 1 to 3 of 3

Thread: Help (select like)

  1. #1
    Cindy Guest

    Default Help (select like)

    I am trying to structure a select statement using the like operator to return records sorted by the third number in a file number.<BR><BR>ie.<BR>sql = "select rm, [File Number], [bid close date], [cult acres], [legal description], [new assess], sold, [total acres] from [bid ad data for land sales] where file number like "___2%"" <BR><BR>How can I represent the first three wildcard numbers?<BR><BR>

  2. #2
    Scott S Guest

    Default RE: Help (select like)

    in MS SQL Server you can use a pattern or a regular expression there. What db are you using? MS SQL, Access, Oracle?<BR><BR>I&#039d check or for more infor or documentation<BR><BR><BR>Scott S<BR><BR>

  3. #3
    Cindy Guest

    Default RE: Help (select like)

    I am using an access database. Can you give me the syntax to try?

Posting Permissions

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