|  | Posted by Roy Harvey on 06/27/07 02:14 
>One alternative is to write your own function that encapsulates the>hardcode.  Pass the table and column names, query the system tables
 >for the type and related information such as max length of a varchar,
 >and then return it.  Clumsy, no doubt.
 
 My apologies, it is nowhere near as simple as I described as, at a
 minimum, one function for each datatype group (dates, character
 strings, etc) would be required.
 
 Roy Harvey
 Beacon Falls, CT
  Navigation: [Reply to this message] |