convert() or cast() in valentina

[Ruslan Zasukhin]

On 2/6/12 6:38 PM, "Giacomo Vernoni" <giacomo at way-out.it> wrote:

> Hi Ruslan,
> RegEx gave me problems so I tried your solution.
> 
> It's useless because:
> 
> ------------------------------------------
> | ImgName           | ImgNumber (method) |
> ------------------------------------------
> | "10.jpg"          | 10                 |
> | "IMG_0010.jpg"    | 0                  |
> | "IMG_0210.jpg"    | 0                  |
> ------------------------------------------
> 
> Your solution only works if the number is at the _beginning_ of the string.
> Is this a bug or a normal behaviour?

Normal.
 
> I need to find images where the numeric part is EXACTLY 10 (in the example
> above). I don't want "IMG_0210.jpg" to appear if user searches for "10" (that
> would be an easy "LIKE '%10%').
> 
> Any other suggestion?

Well, you did not describe it seems all in detail.

Lets start from zero.

* What data you have in records.
 and what you want to get ?

Explain please very detailed.



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