IIF/Format equivalent in TSQL

[andi]

Hi

I have a client application that is currently connecting
to MSAccess via ODBC. It uses the IIF and Format function
in SQL-Statements. I want to migrate to SQL-Server. What
equivalent functions do I have in T-SQL?

thanks

[Anith Sen]

There is no IIF in SQL Server, you'll have to use CASE expression & perhaps
CONVERT and other string functions instead of FORMAT.

--
- Anith
( Please reply to newsgroups only )

[Russell Fields]

See CASE in the BOL for IIF

See CONVERT or CAST for Format. (If I understand Format correctly.)

Russell Fields
"andi" <andi@nospam.com> wrote in message
news:0b1701c33fd2$49f45fe0$a301280a@phx.gbl...

> Hi
>
> I have a client application that is currently connecting
> to MSAccess via ODBC. It uses the IIF and Format function
> in SQL-Statements. I want to migrate to SQL-Server. What
> equivalent functions do I have in T-SQL?
>
> thanks

[Vishal Parkar]

see help on CASE function in BOL. it does the conditional matching of the
resultset.

--
-Vishal
"andi" <andi@nospam.com> wrote in message
news:0b1701c33fd2$49f45fe0$a301280a@phx.gbl...

> Hi
>
> I have a client application that is currently connecting
> to MSAccess via ODBC. It uses the IIF and Format function
> in SQL-Statements. I want to migrate to SQL-Server. What
> equivalent functions do I have in T-SQL?
>
> thanks

[Aaron Bertrand - MVP]

Some info here:

[url]http://www.aspfaq.com/2214[/url]
[url]http://www.aspfaq.com/2460[/url]
[url]http://www.aspfaq.com/2464[/url]




"andi" <andi@nospam.com> wrote in message
news:0b1701c33fd2$49f45fe0$a301280a@phx.gbl...

> Hi
>
> I have a client application that is currently connecting
> to MSAccess via ODBC. It uses the IIF and Format function
> in SQL-Statements. I want to migrate to SQL-Server. What
> equivalent functions do I have in T-SQL?
>
> thanks

[andi]

thanks for all responses

that helped