Nested methods

jda jda at his.com
Mon Jul 18 07:50:11 CDT 2005


>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?
>

Hi Ivan,

I tried sending it to Ruslan to relay to you, but there seems to be a 
problem at his end. What address should I send it to?

Jon


More information about the Valentina mailing list