How to select field which don't contain string value ?

(0) Share

Report

Posted on by Awaxx

229

Hi everyone,

I'm looking for a way to use select statement for a field which don't contain some string value.

I need to look after a particular string word in a string expression for example i want to select values where the field does not contain the word 'happy'.

Is there a way to do that ?

Thanksfully.

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Martin Dráb 237,681 Most Valuable Professional on at

Like (0)

Report
RE: How to select field which don't contain string value ?

It's easy to do, just keep in mind that it needs to do a full table scan, therefore it won't be very fast.

select myTable where !(myTable.MyField like '*hello*');

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

RE: How to select field which don't contain string value ?

i was looking for strContains or strFind or strScan but this way is easier thank you.

Was this reply helpful? Yes No