web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) NVL value in select st...

Microsoft Dynamics AX (Archived)

NVL value in select statement on Dynamics AX

(0) Share

Report

Report

Posted on by Community Member

Hello,

I would like to know how can I add NVL statement (as Oracle does, or a simmiliar statement) to Dynamics AX select statement, please.

Select NVL(myColumn)

from myTable

where ...

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Amir Nazim 5,994 on at

Like (0)

Report
Copy link

Link copied!

i believe it is not supported in AX, you have to use the alternative like

select myColumn from mytable;

mytable.mycolumn = mytable.myColumn ? mytable.myColumn : "default string";

you can use if statement as well.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I see when I do select statement inside X++ code :

When one of the compare columns is null - I cannot see the row (every compare = false. Same as compare in any rational database, so I need a solution for that).

Thanks :)

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

#2

Alexey Lekanov 2

#2

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans