Re: RFC Posted for str_begins and str_ends functions

On 04/08/16 06:50, Stanislav Malyshev wrote: >> I guess that "i" isn't appliable when it have slashes. >> > In this case, functions should be: strbegins, stribegins, strends, striends. >> > In all case, I think that is better a third parameter and keep underlined. > Please, not stribegins. We have enough functions with weird names :) > I am ambivalent of the question whether to have additional argument or > two functions, I guess with a slight preference for argument. The bulk of the time I'm applying this to the SQL query that is going to return a set of results rather than direct to a string. In that case it's STARTING 'xYZ'. Because the need has not arisen I've only just noticed - after 20 odd years - there is no matching ENDING. Although normally one needs to build a phantom field to index the data, so I do have ONE case of reversed_field STARTING 'ZYX'. Is starting just a Firebird SQL thing or is it more generally available. I do a few google searches but as usual when searching for things like 'starting' one gets hundreds of pages on 'running' the software and it's other connotations. I suspect like PHP the other methods of doing things take the strain, so certainly LIKE 'XYZ%' and '%XYZ' are probably the 'generic' solution but suffer from slower search times, especially when looking for the ENDING string. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk