> Hallo,
>
> I receive a string like this " 123x22" or "1x3333"
>
> The signs in front of 'x' should I insert into a separate Variable, also the
> signs after 'x'
>
> How can I separate this in firebird? Substring is not the right, because no
> fixed length.

Why not substring, Olaf?

I mean, as long as the variable is relatively short, you can at least write something like

UPDATE MyTable
SET MyPart1 = case when substring(MyXField from 1 for 1) = 'x' then ''
when substring(MyXField from 2 for 1) = 'x' then substring(MyXField from 1 for 1)
when substring(MyXField from 3 for 1) = 'x' then substring(MyXField from 1 for 2)
when substring(MyXField from 4 for 1) = 'x' then substring(MyXField from 1 for 3)
when substring(MyXField from 5 for 1) = 'x' then substring(MyXField from 1 for 4)
when substring(MyXField from 6 for 1) = 'x' then substring(MyXField from 1 for 5)
end,
MyPart2 = case when substring(MyXField from 1 for 1) = 'x' then substring(MyXField from 2 for 5)
when substring(MyXField from 2 for 1) = 'x' then substring(MyXField from 3 for 4)
when substring(MyXField from 3 for 1) = 'x' then substring(MyXField from 4 for 3)
when substring(MyXField from 4 for 1) = 'x' then substring(MyXField from 5 for 2)
when substring(MyXField from 5 for 1) = 'x' then substring(MyXField from 6 for 1)
when substring(MyXField from 6 for 1) = 'x' then ''
end

With more up-to-date Firebird versions than the one I work with (Fb 2.1 or later), I guess you could write something like:

UPDATE MyTable
SET MyPart1 = substring(MyXField from 1 for position('x' in MyXField) - 1,
MyPart2 = substring(MyXField from position('x' in MyXField) + 1 for length(MyXField))

but I've never used this function.

HTH,
Set