sql-serverselectuser-defined-functionsscalar

Scalar Function To Return the Result of A Select

I want a function to find the maximum allowable length of a field; executed as cmd.ExecuteScalar().

This definition fails, why?

CREATE FUNCTION getPWLen
(
)
RETURNS int
AS
BEGIN
   return select max(len((password))) as return_value from tblSec
END
GO
Solution

  • No need for a column alias, also wrap the SELECT in brackets

    ...
return (select max(len(password)) from tblSec)
...