Sql Help Kaavaali Chaala Simple Jara Ochhi Chusi Answer Cheppunri

[charygaru]

i have a table where i have a column IDnumbers

ee column lo 12 digit numbers unnai and i only want the digits which do not end with "0"

like condition use chesi % use chesi edo chestharu kada endo cheppunri telusthe.

ID numbers:--
123456789000
123456789001
123456789002
123456789003
123456789004
123456789005
123456789006
123456789007
123456789008
123456789009

ee list itla oka 1000 columns undi and last digit la "0" chaala sarlu repeat aythadi

i would like to see the list of idnumbers exlucding the numbers ending with "0"

thanks, help will be appreciated

[Josh]

Nenu temp table meedha tru sesya :

select * from #temp
where IDnumbers not like '%0'

[charygaru]

[quote name='Josh' timestamp='1349357788' post='1302580658']
Nenu temp table meedha tru sesya :

select * from #temp
where IDnumbers not like '%0'
[/quote]

thanks mama nenu "like" use chesthe etla untadi ani alochinchane tappa not like gurinchi alochinchale thanks for the input.

thanks much

[padmasri123]

select * from TABLE_NAME WHERE substr('ID',instr('ID',0,-1)) != 0

[Josh]

Anytime Charygaru... !~>(

[balu_gani]

[quote name='Josh' timestamp='1349357788' post='1302580658']
Nenu temp table meedha tru sesya :

select * from #temp
where IDnumbers not like '%0'
[/quote]
[quote name='padmasri123' timestamp='1349357942' post='1302580664']
select * from TABLE_NAME WHERE substr('ID',instr('ID',0)) != 0
[/quote]

[charygaru]

[quote name='padmasri123' timestamp='1349357942' post='1302580664']
select * from TABLE_NAME WHERE substr('ID',instr('ID',0)) != 0
[/quote]

kanti chupu toh kakunda SQL query toh sampeddam anukunnava mama ??? naaku aa paina josh mma cheppindi work out ayyindi nuvvu cheppindi ardham kuda kaale naaku antha sql raadu

[padmasri123]

[quote name='charygaru' timestamp='1349358174' post='1302580683']
kanti chupu toh kakunda SQL query toh sampeddam anukunnava mama ??? naaku aa paina josh mma cheppindi work out ayyindi nuvvu cheppindi ardham kuda kaale naaku antha sql raadu
[/quote]

Work out indi kada josh mama di no problem ....

[andhrausa]

[quote name='charygaru' timestamp='1349357415' post='1302580634']
i have a table where i have a column IDnumbers

ee column lo 12 digit numbers unnai and i only want the digits which do not end with "0"

like condition use chesi % use chesi edo chestharu kada endo cheppunri telusthe.

ID numbers:--
123456789000
123456789001
123456789002
123456789003
123456789004
123456789005
123456789006
123456789007
123456789008
123456789009

ee list itla oka 1000 columns undi and last digit la "0" chaala sarlu repeat aythadi

i would like to see the list of idnumbers exlucding the numbers ending with "0"

thanks, help will be appreciated
[/quote]

Chary garu, [b]not like[/b] use chesi ila query cheyochu

select [color=#FF0000]column_name[/color] from [color=#ff0000]table_name[/color] where [color=#FF0000]column_name[/color] not like '%0';

[charygaru]

[quote name='Lily' timestamp='1349358547' post='1302580705']
Chary garu, [b]not like[/b] use chesi ila query cheyochu

select [color=#FF0000]column_name[/color] from [color=#ff0000]table_name[/color] where [color=#FF0000]column_name[/color] not like '%0';
[/quote]

the solution i was looking for was provided by josh mama and a high level solution was provided by padmasri mama and your solution is quite simple aswell thanks for helping

[chelsea]

[color=#282828]select [color=#FF0000]column_name[/color] from [color=#FF0000]table_name[/color] where [color=#FF0000]column_name[/color] not like '%0'[/color][list]
[*]
[/list]

[9Pardhu]

SQL Guru twaralo....

[karna11]

CG Not like use cheyyyi, vadukondi CG

[velpu]

[quote name='charygaru' timestamp='1349357905' post='1302580663']
thanks mama nenu "like" use chesthe etla untadi ani alochinchane tappa not like gurinchi alochinchale thanks for the input.

thanks much
[/quote]


chary garu eppudu like ne appudu appudu not like gurinchi kuda alochinchandi

[veerudu]