Hi group,

we concatenate 2 fields together. eg:
segment1||'_'||segment2

Segment1 can have values like: MV200 or MVAR or 100 or whatever.
Segment2 can have values like: A or AA or AB or 1 or 01 or 99 or it can be empty.

How can I check that segment2 is a number? Is there a IsNumeric() function or something like in VB?

Thnx in @vance

VS

yes,

If(IsNumeric(segment2)) then
lalala
else
lololo
end if