ASP.NET, SQL Server, WPF, C#, VB.NET

When we define a VarChar in TSQL we code  
  
DECLARE @Fred VarChar(50)  
  
The "parameter" here sets the length of the VarChar to 50 characters.  
  
In a similar way  
  
DECLARE @George Decimal(10,2)  
  
sets the Precision and Scale of the value.  
  
Question: How does one pass these SqlFacet  parameters (if that's what you  
  
call them) to a UDT or is this not supported (either). ;)  
  
Suppose I want to create a UDT that has varying width, Precision or Scale or  
  
uses the parameter(s) to set specific element criteria or other attributes.  
  
--  
  
____________________________________  
  
William (Bill) Vaughn  
  
Author, Mentor, Consultant  
  
Microsoft MVP  
  
INETA Speaker  
  
www.betav.com/blog/billva  
  
www.betav.com  
  
Please reply only to the newsgroup so that others can benefit.  
  
This posting is provided "AS IS" with no warranties, and confers no rights.  
  
__________________________________

Hello William,  
  
You don't, as far as I can tell. Keep repeating "this is a benefit by design..."  
  
I'm wondering if VB9's Expression-Hole syntax would permit this in Sql.Next  
  
or Sql.Next++. Good question for Vineet.  
  
You'd do what Oracle does, have n-many data types... ;)  
  
Thank you,  
  
Kent Tegels  
  
DevelopMentor  
  
http://staff.develop.com/ktegels/