Concatentation query subject - unable to filter on?

[ry1633]

thanks - I just didn't put two-and-two together that validating an object would also double-check its datatype.

[HalfBloodPrince]

try cast( [Name Column ] , varchar(500))