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