Using Prompts in Case Expressions
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page Using Prompts in Case Expressions
| Line 7: | Line 7: | ||
<pre> | <pre> | ||
case | case | ||
| - | when | + | when DEPTID like :1 then FTE |
else | else | ||
0 | 0 | ||
| Line 17: | Line 17: | ||
<pre> | <pre> | ||
case | case | ||
| - | when | + | when DEPTID like rtrim(:1) then FTE |
else | else | ||
0 | 0 | ||
| Line 24: | Line 24: | ||
In SQL Server, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces). | In SQL Server, rtrim(:1,' ') would resolve the issue (provided there were no leading spaces). | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
==More About Functions== | ==More About Functions== | ||
