convert() or cast() in valentina

[Giacomo Vernoni]

It's all written in my first mail... but here it is again:

> I have a "img_name" field with image names, for example:
> 
> IMG_0010.jpg
> myPicture10a.jpg
> PIC_210_OK.jpg
> 
> I need to search for the images that ONLY have the number 10.
> In my example, I should get the first two records (that have a "value" of 10), excluding the last one that has a value of 210.


Please read the thread (or at least the first post) before saying "you did not describe it seems all in detail".

Giacomo




On 6 feb 2012, at 21:32, Ruslan Zasukhin wrote:

> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina