Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update parcela_conta_receber set nossonumero=REPLACE(nossonumero, '/', '') where nossonumero LIKE'%/%';
- DELETE a FROM boletos_cbx AS a, boletos_cbx AS b WHERE ((a.nossonumeroint=b.nossonumeroint) and (a.sacado_nome=b.sacado_nome) and
- (a.banco=b.banco)
- ) AND a.boleto_nosso_numero like'%/%';
- select * from boletos_cbx where boleto_nosso_numero LIKE'%/%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement