Not sure about simple, but....

declare variable i integer;
begin
My_String =
SUBSTR(My_String,1,1)||'r'||SUBSTR(My_String,3,STRLEN(My_String));
end

SUBSTR and STRLEN are standard UDFs shipped with IB and FB.

You probably need to check that My_String is 3 or more characters long.


-----Original Message-----
From: szsani [mailto:ssani@...]
Sent: 17 December 2001 17:06
To: ib-support@yahoogroups.com
Subject: [ib-support] Setting string value in stored procedure


Hi all

Is there any simple way to change a character of a string in SP
(Like with Pascal : My_String[2]:='r') ?

Thanks

Sandor Szollosi



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=215839.1778785.3296727.1261774/D=egroupweb/S=17050077
09:HM/A=868539/R=0/*http://zappos.zappos.com/bin/zapposset?ref=yahoogroups2>


<http://us.adserver.yahoo.com/l?M=215839.1778785.3296727.1261774/D=egroupmai
l/S=1705007709:HM/A=868539/rand=612330259>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]