Search results

If you have problems with imports use COALESCE and if you have spaces in phone number use regexp_replace and right in sql You can play with this sql SELECT trim( COALESCE(v_contacts.contact_name_given, ' ' ) || ' ' || COALESCE(v_contacts.contact_name_family, ' ' ) || ' (' ||...