Подскажите пожалуйста функцию в PowerBuilder сделать следующее:

Smith, Mary .. rezultat nujen Smith, M
Jacksons, Dan - Jacksons, D
V obschem string funkzia, kotoraia vernet vse do ', ' + 1 char s imeni.
Spasibo

POS funkzia daet mne oshibku..
'pos' is not a recognized built-in function name.

USE [backup_misa]
GO
/****** Object: UserDefinedFunction [dbo].[UDF_Get_short_Name] Script Date: 02/04/2010 15:53:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER function [dbo].[UDF_Get_short_Name]
(@Original_Name varchar(255))
Returns varchar(255) as
BEGIN
declare @char_parm_out varchar(255)

select @char_parm_out = Left( @Original_Name, POS(@Original_Name, ',') + 2)

Return @char_parm_out /*Smith, M*/



END

Ia tak je pitalas zamenit' POS na CHARINDEX ( CHARINDEX vozvraschaet mne 0 v lubih sluchaiah)

Ogromnoe spasibo.. ne tak slojno kak ia dumala.. :)