Nested methods

[jda]

>Anycase you should use much more simple statement:
>
>  SELECT
>	CASE
>		WHEN ... THEN ...
>		WHEN ... THEN ...
>		WHEN ... THEN ...
>		...
>		ELSE  title
>	END
>

I tried this, and still get back an empty string from my method:

SELECT
    CASE
       WHEN LOCATE('The ',title)=1 THEN RIGHT(title, LENGTH(title) - 
LENGTH('The '))
       WHEN LOCATE('An ',title)=1 THEN RIGHT(title, LENGTH(title) - 
LENGTH('An '))
       WHEN LOCATE('A ',title)=1 THEN RIGHT(title, LENGTH(title) - LENGTH('A '))
       ELSE title
    END

Do you see anything wrong with it?

Thanks,

Jon