[V4RB2] Like Statement Error

[Claudius Sailer]

Hi,

Am 25. Mai 2005 um 00:04 Uhr schrieb Bob Keeney:

> I have the following SQL statement:
>
> Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND  
> (sLineText LIKE 'them' no_case)

what do you get, when you use this

Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND  
(sLineText LIKE 'them%' no_case)

OR

Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND  
(sLineText LIKE '%them%' no_case)

OR

Select RecID, * FROM TranscriptDetails WHERE ptrTranscript = 1 AND  
(sLineText LIKE '%them' no_case)

I would say that you LIKE-Statement is wrong. Or do you realy want  
only records where sLineText is only
upper(sLineText)='them'?

bye



Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 5.5.5/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]