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

[Vikas...]

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


-- 
  vikas
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20080407/788d9c01/attachment.html