[V4RB] - CONCAT in WHERE-clause

[Ruslan Zasukhin]

On 7/3/05 5:08 PM, "Erik Scholtz" <anomar at elitecoderz.net> wrote:

>> Erik, you can also use viSQL utility from V4RB Examples/Adcanced
> 
> I checked this with viSQL too, just a view moments ago. Nearly the same
> result as in VStudio: I get a list with NULL-Values. So I modified the
> query a little bit:
> 
> SELECT SUBSTR(phone,1,LOCATE('/',phone)-1),LOCATE('/',phone) FROM usersdata
> 
> 
> With this query viSQL returns a list like this:
> ---------
> NULL 5
> NULL 7
> NULL 5
> NULL 6
> ---------
> 
> 
> VStudio returns a list like this one:
> ---------
> No_name2
> 5
> 7
> 5
> 6
> ---------
> The first column is dropped by Vstudio and not displayed.
> 
> 
> The LOCATE-Command works fine if it is used "standalone" - but it does
> not work, when used in the SUBSTR-command.

Ivan, please check this point.

Erik, you can use the next workaround I think.
Make 2 methods. First do SUBSTR, second LOCATE.


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