--- In [email protected], Ahmad $arhan **** <mahdoo...@...> wrote: > > Hello ! > > Guys I need sql statment to remove white spaces from the middle of strings > such as "A 01" needed as "A01" using IB Expert ( firebird DB). > > ** the function 'REPLACE' is not defined in the IB Expert compiler. > > Thanks,
Ahmad, SQL is a set language you are looking for a procedural ability. You could probably do this with a database procedure. Mick
