`I want to create this function but facing issue
CREATE OR REPLACE FUNCTION RAW.getType(input_string VARCHAR)
RETURN VARCHAR AS
BEGIN
RETURN (
SELECT Type
FROM RAW.TYPE
WHERE LENGTH(input_string) = LENGTH
AND input_string LIKE PATTERN || ‘%’
LIMIT 1
);
END;

Gives Error as Column “input_string” does not exist

also tried with declare result

CREATE OR REPLACE FUNCTION RAW.getType(num VARCHAR)
RETURN VARCHAR
AS
BEGIN
DECLARE result VARCHAR;

SELECT Type INTO result
FROM RAW.TYPE
WHERE LENGTH(num) = LENGTH  
  AND num LIKE PATTERN || '%'  
LIMIT 1;  

RETURN result;

END;
This gives the syntax error

Need to create function query for above select query`