>Yes it wouldn't be visible.
>But you could try sql_variant (Kill me I can't remember if this type is available in SQL Server 2000)
>
>DECLARE @Test sql_variant
>SET @Test = 'asdasdasdasdasda'
>SELECT @Test
>SET @Test = 0
>SELECT @Test
>SET @Test = GETDATE()
>SELECT @Test
>
>
>UPDATE: I just checked. sql_variant is introduced in SQL Server 2000 so you could use it when you don't know the type.
Thanks, this may work.
If it's not broken, fix it until it is.
My Blog