The command line is a powerful tool at the disposal of every Linux user. Although Linux distros come with beautiful user interfaces, it's worthwhile to learn the command line because it allows you to do a number of things that you otherwise cannot do from the GUI.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Wildcard in dataset filter query
Posted on 2013-01-08
Hello
I'm adding a query with a filter to a dataset with the designer.
My query is:-
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM SiteDetails
WHERE (Postcode = @POSTCODETOFIND )
This works OK but I'm struggling to get the LIKE and wildcard option to work.
Please could you suggest the correct syntax.
Thanks
I'm adding a query with a filter to a dataset with the designer.
My query is:-
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM SiteDetails
WHERE (Postcode = @POSTCODETOFIND )
This works OK but I'm struggling to get the LIKE and wildcard option to work.
Please could you suggest the correct syntax.
Thanks
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
2
5 Comments
If your passing the wildcard to sql as part of a variable, then it's pretty easy to handle.
If you're trying to add it to your variable within your sql statement it has to be handled a little differently.
ex.
This works:
declare @name as varchar(15)
set @name = 'smit%'
select * from staff where lastname like @name
This, or any variation of this, won't work:
declare @name as varchar(15)
set @name = 'smit'
select * from staff where lastname like (@name + '%')
So with your code you can do this:
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM SiteDetails
WHERE (Postcode = @POSTCODETOFIND ) OR (Postcode LIKE @POSTCODETOFIND )
as long as you're setting the wildcard character in your variable prior to passing it to sql.
If you're trying to add it to your variable within your sql statement it has to be handled a little differently.
ex.
This works:
declare @name as varchar(15)
set @name = 'smit%'
select * from staff where lastname like @name
This, or any variation of this, won't work:
declare @name as varchar(15)
set @name = 'smit'
select * from staff where lastname like (@name + '%')
So with your code you can do this:
SELECT Counter, SiteRef, ccount, SiteName, AddressLine1, AddressLine2, AddressLine3, Town, Postcode
FROM SiteDetails
WHERE (Postcode = @POSTCODETOFIND ) OR (Postcode LIKE @POSTCODETOFIND )
as long as you're setting the wildcard character in your variable prior to passing it to sql.
Hello, thanks for looking at this.
With your help I've got it to work but I'm struggling to understand the following.
If I use:-
" Dim strFind As String
strFind = Trim(txtPostcode.Text) + "%"
Me.SiteDetailsTableAdapter
it doesn't work. However if I use:-
Dim strFind As String
strFind = Trim(txtPostcode.Text) + "%%%%%%"
Me.SiteDetailsTableAdapter
it does work. I thought the "%" should match any string.
With your help I've got it to work but I'm struggling to understand the following.
If I use:-
" Dim strFind As String
strFind = Trim(txtPostcode.Text) + "%"
Me.SiteDetailsTableAdapter
it doesn't work. However if I use:-
Dim strFind As String
strFind = Trim(txtPostcode.Text) + "%%%%%%"
Me.SiteDetailsTableAdapter
it does work. I thought the "%" should match any string.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 19 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.