Re: What does columnname::datatype do in a where clause

[J Jorgenson]

Your where clause would be translated into:

WHERE Reseler_Profile.Status_ID = Reseller_Status.Status_ID AND
(param_Reseller_Id IS NULL or CAST(Reseler_Profile.Reseller_Id AS CHAR(4)) LIKE param_Reseller_Id)

The ::CHAR(4) was replaced with CAST( xxx AS CHAR(4))

However, I recommend to avoid a CAST in a situation where you'll be increasing the field size, or where performance is an absolute must. It would be better to reduce the 'other' field's size rather than increase a size.