>We have a field in the database populated with the Workstation # UserID. In SQL Server, I need to pull back just the workstation part of the field. In VFP I would use the at() function to get the starting location of the #, but I'm not sure how to do that in SQL Server.
>
>
>Sample Field value: SFM-ADM-01MAIN # KIRK.KELLY
>
>Thanks
>
>Kirk

Look at charindex() and substring() functions.