[DUG] Need help in type casting in SQL sever 2000 data type with delphi 5

[Neven MacEwan]

Vikas

it would simply be select cast(11 as UserType) as in

select cast(11 as sysname)

HTH

Neven
> Hi,
>  
> I am not sure wether this is the right palce to ask this question i 
> have a simple query related to sql sever data type converstion
>  
> Actually i have developed an application using delphi5 and sql sever 
> 2000. Now my problem is when i dveloped the application i have used 
> varchar in many places as datatype for the column of the table. Now my 
> cleitn wants to sue as user defined datatype.
>  
> That before i had value as string
> ex:
> l1 := 'vikas';
>  
> str := 'cast(l1 as varchar(2))'
>  
> this was fine
>  
> now i have datatype as user defined
>  
> say user_type(varchar)
>  
> now anyone knwos how to cast it
>  
> when i tried
>  
> *cast('vikas' as user_type(varchar)(2))*
> ** 
>  
>  
> it dint worked
>  
> i know the casting system or soemthign is wrong
>  
> i am not sure where i am going wrong.
>  
> Please anyone guide me thought it. I will really apreciate it
>  
> Regards
> Vikas
> Solution consultant
> National cash register
> www.ncr.com <http://www.ncr.com>
>
>
> -- 
>   vikas
> ------------------------------------------------------------------------
>
> _______________________________________________
> NZ Borland Developers Group - Delphi mailing list
> Post: delphi at listserver.123.net.nz
> Admin: http://delphi.org.nz/mailman/listinfo/delphi
> Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe