LIKE stored procedure conundrum

[oddball]

When i pass the following stored procedure the variable @LetterRange with values:

a-e

or

abcde

why do i only receive back company names begining with 'a'?

===========================================================

ALTER PROCEDURE GetAlphabeticalCompanies
(
@LetterRange VarChar
)
AS

SELECT
CompanyID,
CompanyName

FROM
Company

WHERE
CompanyName LIKE '[' + @LetterRange + ']%'

ORDER BY
CompanyName

===========================================================

cheers,

si

 

[oddball]

Fixed it!

should have put:

@LetterRange nvarchar(3)

when sending a-e, doh!