Returning a partial string

[Ruslan Zasukhin]

On 7/7/05 11:19 PM, "jda" <jda at his.com> wrote:

>> First of all, I'd suggest put this formula into Table Method,
>> Because they you get permanent index on it.
> 
> OK, although speed here is not important. Not having to alter
> existing tables is a plus.

Numeric position in the SELECT


>> Second, I think it needs put formula into SELCT
>> And use
>>   
>>     ORDER 12
> 
> ORDER 12? Sorry, I don't understand.
> 
>> 
>> Or give it in select alias name
>> 
>> SELECT Left(textField, (LOCATE(chr(13), textfield))) as 'aaa'
>> FROM T
>> ORDER BY aaa

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]