| Author |
find a word in the field
|
|
| bijan 2005-06-04, 11:24 am |
| hi
for example i wrote good boy in a field
and i want find boy.
i wrote locate for nn='boy'
nn is name of field it is a memo field
but it dont find it what must i use to find this record ofcourse maybe there
is more record it must find
thank you
| |
| Christian Ehlscheid 2005-06-04, 1:24 pm |
| Hi,
LOCATE FOR "boy" $ nn
Regards
Christian
"bijan" <bijan@discussions.microsoft.com> schrieb im Newsbeitrag
news:889BFDA2-D848-4775-9FEB- 03C5710D2311@microso
ft.com...
> hi
> for example i wrote good boy in a field
> and i want find boy.
> i wrote locate for nn='boy'
> nn is name of field it is a memo field
> but it dont find it what must i use to find this record ofcourse maybe
there
> is more record it must find
> thank you
>
| |
|
| Hi
thank you christian
it is working very good
>
| |
| Stephen & Shelagh Ibbs 2005-06-05, 11:23 am |
| Be aware that this will be case specific - so if you have 'Boy' entered in
the field rather than 'boy' it will fail.
To make it find 'boy' whether BOY, Boy or boy, use
LOCATE for "BOY" $ upper(nn)
HTH
Stephen
"bijan" <bijan@discussions.microsoft.com> wrote in message
news:E85EAF89-00CE-4A6B-8F8A- 63E1BD57E745@microso
ft.com...[color=darkred]
> Hi
> thank you christian
> it is working very good
|
|
|
|