Nested methods

[Ivan Smahin]

jda wrote:
> 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?
> 

Seems to be correct query. Could you send me some sample project for 
testing?

-- 
Best regards,
Ivan Smahin