Scalar Function To Return the Result of A Select

Question

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

Answer 1

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

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