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: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe
