Re: [SQL] simple text parsing function

2008-11-22 Thread John DeSoi
On Nov 21, 2008, at 3:35 PM, Kevin Duffy wrote: select getrfs_bbcode('BPZ8 CURNCY ', NULL, NULL); returns nothing. I need to receive 'BPZ8 CURNCY ' in this case. What am I missing? I think it is because of your choice of types: select rtrim('BPZ8 CURNCY

[SQL] simple text parsing function

2008-11-21 Thread Kevin Duffy
Hello All: I am requesting your kind assistance with a simple text parsing function. The source code for the function is below. What is interesting is that the path through the code that actually does something works. The simple path through the code fails. For example select getrfs