Whole Word, Case Sensitive control

[Juergen Schreck]

Hi,

How do I implement the following in V4RB 1.1.0:

I have a table 'clips' containing a 512 byte VarChar column 'cliptext'. 
I set this column to be indexed and indexedByWords. The user options to 
search this 'cliptext' field at runtime need to be:

Match Case
Match Whole Word

So I need:

'Contains' case-sensitive
'Contains' case-insensitive
'Match whole word/phrase' case-sensitive
'Match whole word/phrase' case-insensitive

The search options are to be user settable at runtime. Could someone 
help me with the SELECT statements?

Thanks,
Juergen