DECLARE @str varchar(50)
SET @str = 'SFM-ADM-01MAIN # KIRK.KELLY'
SELECT LEFT(@str, CHARINDEX(' #', @str)-1) 

>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