Hi,

Why I can't use IIF with set expression?
For example

with

set myset as 'IIF(a<b, SetExpression1, SetExpression2)'

select

....

I there any workaround?
In AS2005?

Thanks
Vladimir

I have an workaround under AS2000. It is StrToSet and SetToStr.

But it is pure ( counting exercise.


"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> schrieb im
Newsbeitrag news:uPvc0AKMGHA.420 (AT) tk2msftngp13 (DOT) phx.gbl...

In AS2005 it is out of box supported.

"Vladimir Chtepa" <vc.nospam (AT) diacom-systemhaus (DOT) nospam.de> schrieb im
Newsbeitrag news:uPvc0AKMGHA.420 (AT) tk2msftngp13 (DOT) phx.gbl...

In AS 2000, the IIF statement can only return strings or integers. And
both sides of the statement need to use the same data type

eg:

IIF( a < b, Str1, Str2)

or:

IIF( a < b, int1, int2)

something like:

IIF( a < b, Str1, int2)

will not work. Thus your work around of using StrToSet is all you can do
in AS 2000.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <uPvc0AKMGHA.420 (AT) tk2msftngp13 (DOT) phx.gbl>, vc.nospam@diacom-
systemhaus.nospam.de says...