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.