If Condition in where clause

[dhananjay_capge]

Hi There,

Can we use If condition in where clause?

If yes could plz share the example with syntax

Thanks,
DJ

[mohamed_ahid]

see the sample .

[jonathandienst · Accepted solution]

Hi

Not sure that I understand. A WHERE clause is already a type of if:

LOAD ....

FROM .....xlsx (ooxml, ...)

Where Len(Code) > 0;

HTH

Jonathan

[mohamed_ahid]

may be he wants to select the condition of where depending on a if result . its useful if we use a parameter file (with variables)