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
dwiniers
0
Junior Poster in Training
Recommended Answers
Jump to PostAssuming 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.
All 2 Replies
BitBlt
452
Practically a Master Poster
Featured Poster
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.
dwiniers
0
Junior Poster in Training
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.