Posts by Bruno Alvim • 21 points

• 2

  votes

  1

  answer

  718

  views

  A: Mask CNPJ in Firebird

  In Firebird the concatenation symbol of Strings is || and not +, that was the error. UPDATE EMPRESA SET EMP_CPF_CNPJ = SUBSTRING(EMP_CPF_CNPJ from 1 for 2) || '.' || SUBSTRING(EMP_CPF_CNPJ from 3…

  firebird

  answered 3 years, 10 months ago Bruno Alvim 21