Very Computer

Hi,

I can't remember the  SQL String function with 3 args that tests a value :

("text to test", "test" , "value is the test is OK")

if "text to test" = "test" the function returns "value is the test is OK"
else the function returns "text to test"

Thanks in advance,

Stephane.

Quote:> Hi,

> I can't remember the SQL String function with 3 args that tests a
> value :

> ("text to test", "test" , "value is the test is OK")

> if "text to test" = "test" the function returns "value is the test
> is OK" else the function returns "text to test"

I think you're thinking of the Oracle function DECODE() which does
this.  You can do this now in Sybase (and Oracle) using the CASE()
statement.
--
Pablo Sanchez, Blueoak Database Engineering
http://www.blueoakdb.com