| Author |
no diffrent between 'b' and 'B' in search
|
|
|
| Hi
When I use select command to find a record
Bd='bijan'
For example select * from di where bd $ g………
It don’t find recors have capital letter for example 'BIJAN'
How can set search to find 'bijan' and 'BIJAN'
thank you
| |
| Stefan Wuebbe 2005-12-06, 3:24 am |
|
"bijan" <bijan@discussions.microsoft.com> schrieb im Newsbeitrag
news:37332FFB-E640-4944-8E0D- 028FFF47C156@microso
ft.com...
> Hi
> When I use select command to find a record
> Bd='bijan'
> For example select * from di where bd $ g...
> It don't find recors have capital letter for example 'BIJAN'
> How can set search to find 'bijan' and 'BIJAN'
> thank you
Try Upper() or Lower(), e.g. "select * from di where Upper(bd) $ Upper(g..."
See also "Set Ansi" and Sys(3054) in help.
hth
-Stefan
--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------
| |
| Fred Taylor 2005-12-06, 9:25 am |
| You could also use ATC():
SELECT * FROM yourtable WHERE ATC("BIJAN",yourfield)>0 ...
--
Fred
Microsoft Visual FoxPro MVP
"bijan" <bijan@discussions.microsoft.com> wrote in message
news:37332FFB-E640-4944-8E0D- 028FFF47C156@microso
ft.com...
> Hi
> When I use select command to find a record
> Bd='bijan'
> For example select * from di where bd $ g...
> It don't find recors have capital letter for example 'BIJAN'
> How can set search to find 'bijan' and 'BIJAN'
> thank you
|
|
|
|