Member Avatar for dwiniers

SQL = "SELECT * FROM tbldes WHERE Category LIKE '%" & Replace(Trim(Text1.Text), "'", "''") & "%' ORDER BY category"
rs.Open SQL, cn, 2, 3

use of this sign(%)
anybody can explain me, what is the use of this code?


br

  • 2 Contributors
  • 2 Replies
  • 121 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by dwiniers
Member Avatar for BitBlt

Assuming your database is hosted on a MS SQL Server, the % sign is used as a wildcard character in the "LIKE" clause. So if you have
select * from myTable where name like '%smi%'
You would get "Joe Smith", "Jasmine Jones" "Smiling Dave" and so on.

Member Avatar for dwiniers

Assuming your database is hosted on a MS SQL Server, the % sign is used as a wildcard character in the "LIKE" clause. So if you have
select * from myTable where name like '%smi%'
You would get "Joe Smith", "Jasmine Jones" "Smiling Dave" and so on.

Thank you very much sir. It very will explain.....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.