News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to select field wh...

Finance | Project Operations, Human Resources, ...

Answered

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

(0) Share

Report

Report

Posted on by Awaxx

205

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.

All responses Img

All responses (2)

Answers Img

Answers (1)

Awaxx 205 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.
Verified answer

Martin Dráb 230,466 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*');

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2

Martin Dráb 230,466 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans