[SQL] Substitute a Character

[Judith]

   Hello everybody!!  
  
   I have a field type text with folios like this: A98526

   but I want to change de A for a 0 like this: 098526, exists a way to 
do this in a query???

   Thanks in advanced!!!



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend