We have recently migrated from Sybase/SAP ASE to MSSQL Server. master..syslogins in sybase has two columns name and fullname. Name would be AD alias name and fullname is Full Name of the user. Example...Dan Brown is the user and his AD alias would be BrownD. Now, in SQL Server i created logins using their AD alias. How would i get the full name from the alias name in SQL Server. Is there any function/sp available in SQL Server? Thanks for your help.