0

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
3
Views
5 Years
Discussion Span
Last Post by dwiniers
1

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.

0

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.....

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.