|
 |
access thread: sql % character
Message #1 by "Darin Marsh" <netadmin@l...> on Fri, 28 Feb 2003 17:55:27
|
|
what roll does the % sign play in the following:
Where FieldName = '%value%'
Thanks
Darin
Message #2 by "Darin Wray" <darin@r...> on Fri, 28 Feb 2003 11:55:17 -0600
|
|
% is a wildcard character..
For example...when doing a search on a customer's first name....and you want
to see all customers who's name start with the letter J...you'd use Like
'J%' for your criteria.
Your results might be John, Jane, Jim, etc... using Like 'JA%' would yield
Jack, Jane, Jason...but not John or Jim.
Using Like '%AR%' might yield...Harry, Harper, Garrett, Larry
hope this helps,
Darin
(and, it's amazing...you spell it the same way I do)
----- Original Message -----
From: "Darin Marsh" <netadmin@l...>
To: "Access" <access@p...>
Sent: Friday, February 28, 2003 5:55 PM
Subject: [access] sql % character
> what roll does the % sign play in the following:
>
> Where FieldName = '%value%'
>
> Thanks
> Darin
>
Message #3 by "Darin Marsh" <netadmin@l...> on Fri, 28 Feb 2003 18:17:28
|
|
> % is a wildcard character..
For example...when doing a search on a customer's first name....and you
want
to see all customers who's name start with the letter J...you'd use Like
'J%' for your criteria.
Your results might be John, Jane, Jim, etc... using Like 'JA%' would yield
Jack, Jane, Jason...but not John or Jim.
Using Like '%AR%' might yield...Harry, Harper, Garrett, Larry
hope this helps,
Darin
(and, it's amazing...you spell it the same way I do)
Thanks for the quick reply, and yes, it is cool to see another with the
same spelling.
How does the % differ from the *? I'm an old DOS man and I'm very
familiar with the * even in my sql, but I saw this % and was thrown. Are
these two wildcard synonymous, maybe one DBMS requires % and another the *?
Regards,
----- Original Message -----
From: "Darin Marsh" <netadmin@l...>
To: "Access" <access@p...>
Sent: Friday, February 28, 2003 5:55 PM
Subject: [access] sql % character
> what roll does the % sign play in the following:
>
> Where FieldName = '%value%'
>
> Thanks
> Darin
>
Message #4 by "Darin Wray" <darin@r...> on Fri, 28 Feb 2003 12:11:15 -0600
|
|
exactly
* used in Access
% used in SQL Server
Darin
----- Original Message -----
From: "Darin Marsh" <netadmin@l...>
To: "Access" <access@p...>
Sent: Friday, February 28, 2003 6:17 PM
Subject: [access] Re: sql % character
> > % is a wildcard character..
>
> For example...when doing a search on a customer's first name....and you
> want
> to see all customers who's name start with the letter J...you'd use Like
> 'J%' for your criteria.
> Your results might be John, Jane, Jim, etc... using Like 'JA%' would
yield
> Jack, Jane, Jason...but not John or Jim.
> Using Like '%AR%' might yield...Harry, Harper, Garrett, Larry
>
> hope this helps,
> Darin
> (and, it's amazing...you spell it the same way I do)
>
> Thanks for the quick reply, and yes, it is cool to see another with the
> same spelling.
>
> How does the % differ from the *? I'm an old DOS man and I'm very
> familiar with the * even in my sql, but I saw this % and was thrown. Are
> these two wildcard synonymous, maybe one DBMS requires % and another the
*?
>
> Regards,
>
> ----- Original Message -----
> From: "Darin Marsh" <netadmin@l...>
> To: "Access" <access@p...>
> Sent: Friday, February 28, 2003 5:55 PM
> Subject: [access] sql % character
>
>
> > what roll does the % sign play in the following:
> >
> > Where FieldName = '%value%'
> >
> > Thanks
> > Darin
> >
>
>
Message #5 by "Darin Marsh" <netadmin@l...> on Fri, 28 Feb 2003 19:18:46
|
|
> exactly
* used in Access
% used in SQL Server
Darin
----- Original Message -----
From: "Darin Marsh" <netadmin@l...>
To: "Access" <access@p...>
Sent: Friday, February 28, 2003 6:17 PM
Subject: [access] Re: sql % character
> > % is a wildcard character..
>
> For example...when doing a search on a customer's first name....and you
> want
> to see all customers who's name start with the letter J...you'd use Like
> 'J%' for your criteria.
> Your results might be John, Jane, Jim, etc... using Like 'JA%' would
yield
> Jack, Jane, Jason...but not John or Jim.
> Using Like '%AR%' might yield...Harry, Harper, Garrett, Larry
>
> hope this helps,
> Darin
> (and, it's amazing...you spell it the same way I do)
>
> Thanks for the quick reply, and yes, it is cool to see another with the
> same spelling.
>
> How does the % differ from the *? I'm an old DOS man and I'm very
> familiar with the * even in my sql, but I saw this % and was thrown. Are
> these two wildcard synonymous, maybe one DBMS requires % and another the
*?
>
> Regards,
>
> ----- Original Message -----
> From: "Darin Marsh" <netadmin@l...>
> To: "Access" <access@p...>
> Sent: Friday, February 28, 2003 5:55 PM
> Subject: [access] sql % character
>
>
> > what roll does the % sign play in the following:
> >
> > Where FieldName = '%value%'
> >
> > Thanks
> > Darin
> >
>
>
Understood, Thanks man.
|
|
|
View Cart
