Comparing a SQL field to a string 1

[FengShui1998]

Hello,

I have an SQL field called IMEI that contains data "01 353443 3444 555".
Is there a way to input a search string "013534433444555" that eliminates the spaces in SQL query and finds the record "01 353443 3444 555"?

Thanks ahead,
fengshui1998

 

[imex]

Hi,

Try something like that:

select * from MyTable
where REPLACE(IMEI, ' ', '') = '013534433444555'

Hope this helps.

[URL unfurl="true"]http://www.imoveisemexposicao.com.br/imoveis-venda-são_paulo-residencial-apartamento[/url]