convert() or cast() in valentina

[william humphrey]

Ruslan needs more detailed question because if the format is always:

"IMG_####.jpg that you can search using wildcards.

On Mon, Feb 6, 2012 at 4:32 PM, Ruslan Zasukhin <
ruslan_zasukhin at valentina-db.com> 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
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120206/110725c6/attachment.html>