SQL: Testing The Type Of A Variable

[RamziAbb]

Does anyone know how to test the type of a variable in SQL?

Something like

If (TypeOf(@myVariable), varchar) Then
.
.
.


of course TypeOf isn't an SQL function.

Thanks,
Ramzi

[panayotisk]

I think that SQL server variables cannot be of a polymorphic type.
I mean if the cariable is declared as varchar then stays varchar... What do you want to achieve by such a test? There may be some other way out of this.

[Davey]

If you look at INFORMATION_SCHEMA.COLUMNS you can see all your column types.