Typecasting in sql

[Ruslan Zasukhin]

On 21/2/07 8:10 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> I'm looking on how a method would need to look where Field A
> (varchar) + Field B (integer) + Field C (varchar) = my uniqueconstraint

 
> Otherwise said how can I typecast an integer field to a varchar so
> concat will work in a methodfield.

    concat( f1,f2, f3)
 
No need do special casts.

Btw, Method's TYPE already specify RESULT of function.


> Look around on the wiki but failed to find something.
> Maybe I saw a few days ago something with ::
> 
> A little example would be nice

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