About HASHBYTES (from http://msdn.microsoft.com/en-us/library/ms174415.aspx):

1. input size is limited to 8000

2. output size depends on used algorithm, for MD5 you can use CAST(HASHBYTES('MD5', (EmployeeName + CityName)) AS BINARY(16))

3. beware addition NULL values