Posts by j_ferrareze • 1 point
2 posts
-
0
votes1
answer197
viewsQ: Search item result in same line separated by comma
I have a select that returns the risks (work safety) in several lines, I would like the item "T4.RIS_RISCO" to appear in a single line separated by comma, can anyone help me?? have basic…
-
0
votes1
answer718
viewsQ: Mask CNPJ in Firebird
I need to mask my CPF field / CNPJ direct on Firebird, I tried the command below but it shows error, can anyone help me? UPDATE EMPRESA SET EMP_CPF_CNPJ = SUBSTRING(EMP_CPF_CNPJ from 1 for 2) + '.'…
firebirdasked j_ferrareze 1