• 1 reply
  • Latest Post - ‏2013-11-13T18:07:01Z by krmilligan
21 Posts

Pinned topic BIFs Locate Position PosStr

‏2013-11-12T22:07:23Z |

Which one would be best for use in a View, Locate, Position, or PosStr?

I have a field with three values in it separated by a space (i.e.  "aa bbbbb cccccccccc") and I need to list them as separate fields. 

The first field will be one OR two characters long.  The second field will be (should be) five character long, and the third could be the rest of the original field (in length).

I can probably get away with just knowing the position of the first blank space and do all my parsing from there (using SUBSTR).

I have seen in the reference manual that the LOCATE has one additional parameter for a starting position, but other than that distinction there doesn't seem to be much of a difference between the three BIFs (for my needs), or is there a difference that I'm may not be aware of?



  • krmilligan
    450 Posts

    Re: BIFs Locate Position PosStr


    I think that the performance of all 3 functions would be similar.   The functions did have some differences if you were dealing with double-byte characters, but I'm guessing that your column just contains traditional single-byte characters.