Supported generic argument types

You use the ANY keyword to indicate that an argument or return value is generic. The following data types support the ANY keyword as a size specifier:
  • CHAR or NCHAR
  • VARCHAR or NVARCHAR
  • NUMERIC

For example, to specify a numeric data type of precision 10 and scale 2, you specify it as NUMERIC(10,2). To specify a numeric data type that can take any size, you specify is as NUMERIC(ANY). Likewise, to specify a variable character string that can take any size, you declare it as VARCHAR(ANY).