I just realized that a lot of queries that are in our project have the following in them:
What is the affect of not specifying a length for the varchar?
I've seen in someone's notes that it defaults to 30 and I've tested that in SQL Analyzer and it holds true:
select convert(varchar, '1234567890123456789012345678901234567890')
returns: 123456789012345678901234567890 (30 chars)
Is this a default in QA or does this hold true?