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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-20 : 08:38:24
|
| Kenny writes "I'm trying to upgrade an app. using Access to SQL, but have had problems with control statments.The following works in Access but not SQL. If(deallegs.SettlementType='Advance','ADV','ARR') AS Adv_Arr_Indicator," |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-05-20 : 09:19:25
|
the immediate if function: if( {predicate}, {true value}, {false value} ) is not a SQL function, but rather an internal Access function. T-SQL does implement a similar construct with its CASE statement, however.quote:
Kenny writes "I'm trying to upgrade an app. using Access to SQL, but have had problems with control statments.The following works in Access but not SQL. If(deallegs.SettlementType='Advance','ADV','ARR') AS Adv_Arr_Indicator,"
setBasedIsTheTruepath<O> |
 |
|
|
|
|
|
Access to SQL