Results 1 to 7 of 7

Thread: 'LIKE' Statement and '%'

Threaded View

  1. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    create table test112 (id int, name char(30))
    insert into test112 select 1,'100 % detail'
    insert into test112 select 1,'My detail 5 % detail'
    insert into test112 select 1,'60 % detail'
    insert into test112 select 1,'60 % detail'
    insert into test112 select 1,' My detail 17 %'

    select * from test112 where name like '%5 [%]%'
    Last edited by MAK; 07-10-2003 at 08:06 AM.

Posting Permissions

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