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