Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anjan
Starting Member
21 Posts |
 Posted - 2005-09-29 : 13:40:08
|
| I'm converting a vb/access project to vb/sqlserver.In my vb code huge no of IIF statements are there.we don't have the same function in sql server.can i write the function for the same...(with case statemnts).So that i can use the the same name in the VB Code. justy by replacing the IIf(...) with ownername.IIF(..).Is it possible...plz post reply asap |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-09-29 : 13:43:52
|
| SQL supports IF statements to control execution flow.CASE statements return a value, conditionally, but do not control execution flow. |
 |
|
|
|
|
|
IIF Function