Truncating Date Time In SQL To Use In Datagrid

I am attempting to bind a smalldatetime field to a datagrid and want to truncate the time off the end of the field so only the date shows up.





Here is the query that I am using:





Select





UserId,


Lastname + ',' + ' ' + Firstname as MembName,


Convert( datetime, Convert( int, MembExpiryDate))





FROM Users








In the datagrid, I have referenced a data element called MembExpiryDate, but with the above query, it no longer recognizes this filed.





If I use





Select





UserId,


Lastname + ',' + ' ' + Firstname as MembName,


MembExpiryDate





It works fine, the date is bound to the grid, but the time is still included obviously.





If I use





Select





UserId,


Lastname + ',' + ' ' + Firstname as MembName,


Convert( datetime, Convert( int, MembExpiryDate)) as ExpiryDate





and reference Expiry date in the datagrid instead, the time is still included.





Any ideas how to write this query to remove the damn time?





Thanks.





Dave