Posts by Ceranto • 11 points
1 post
-
1
votes2
answers203
viewsA: Query data with mask - SQL Server
Good Afternoon, I recommend to treat the masks in some application. But if you want directly in SQL try the following query: SELECT DESCRICAO_PATRIMONIO FROM PATRIMONIO WHERE UPPER(NUM_PATRIMONIO)…