Custom Expression in SQL

[Fergal1982]

Does anyone know how to set up a custom expression using T-SQL?

I basically have a query that returns a bit column. I need to provide custom output from the query so that, if the value is 1 it returns a set string.

Does that make any sense?

[Ossian]

Define a custom function e.g. ProcessBit taking the bit value as a parameter

e.g.
CREATE FUNCTION dbo.ProcessBit( @booVal bit)
RETURNS varchar(20)
AS
BEGIN
IF @booVal --should default to true
RETURN 'True String'
ELSE
RETURN 'False String'

END


then

SELECT ProcessBit(fieldname) AS "Result" FROM tablename

Note this is not checked code, just a rough example!

[Fergal1982]

Yeah I thought of doing that. Didnt want to use stored procedures if i could avoid it.

Dont worry too much though, I realised I was being stupid and doing the wrong query, so its a moot point.