Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Location
    Czech Republic
    Posts
    82

    Unanswered: How to search for text with underline using "like" command...

    Hello,

    I have problem with serching for underline text e.g.

    I want to list all objects starting with t_

    t_test
    t_users
    t_tables
    ...
    ...
    ...

    But I cannot simply write: select * from sysobjects where name like 't_%'

    Because [ _ ] represents any character.... so I get

    test
    test1
    t_test
    t_users
    Last edited by Musil David; 02-12-07 at 10:56.

  2. #2
    Join Date
    Jun 2006
    Posts
    16
    Try [_] Within the square bracket

Posting Permissions

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