address query

[hgriva]

hi,
i have a table called address
whose structure is
adr number
street_number varchar2(50

there are recoords like

9999 0000045
9991 45
9992 0001045
9993 0010045

the user would enter say 45 on the front end java screen and the
query has to fetch records of street_number 45 as well as 0000045

[debasisdas]

You need to use LIKE in the search .

try to use

select ............... ............... ..where ............... like ('%45')

[hgriva]

You need to use LIKE in the search .

try to use

select ............... ............... ..where ............... like ('%45')

No it would fetch me records whose street number would be like

0000045
0000145
0001045

But i want only 45 and 0000045 to be returned.

[amitpatel66]

No it would fetch me records whose street number would be like

0000045
0000145
0001045

But i want only 45 and 0000045 to be returned.

Try

SELECT......... ...........WHER E.............. ='45' OR............. ..LIKE '%0045'

Could you please explain your requirement in detail to why you need to do this?

[QVeen72]

Hi,

Try this :

[code=oracle]
Select * From MyTable Where adr Like '% 45' Or adr Like '%0000045'
[/code]


Regards
Veena