i need to get a record from EQUi table . i have a serial number(sernr) '000a123456'
iam getting the record if i give like this
select single * from equi
where sernr = '000a123456'.
but not if i give sernr = 'a123456'.
how to write the select statement.
thanks in advance