Sql Help Kaavaali Chaala Simple Jara Ochhi Chusi Answer Cheppunri

[charygaru]

[quote name='deals2buy' timestamp='1349374055' post='1302581905']


is it? inthaki "instr" em chestadi aa code lo?
[/quote]

thanks my doubt exactly [img]http://i51.tinypic.com/1z3xr8i.gif[/img]

[tom bhayya]

[quote name='lolliman' timestamp='1349374030' post='1302581903']

golikaya etlunnav??
[/quote]


[img]http://www.desigifs.com/sites/default/files/rt%201%20%283%29.gif?1289984827[/img] lolli baa

[tom bhayya]

[quote name='charygaru' timestamp='1349374158' post='1302581919']
thanks my doubt exactly [img]http://i51.tinypic.com/1z3xr8i.gif[/img]
[/quote]
Returns the starting position of the specified expression in a character string.

[charygaru]

[quote name='Alexander' timestamp='1349374285' post='1302581941']
Returns the starting position of the specified expression in a character string.
[/quote]

starting position ki poyi em peekedi untadi ??? ardham aythe mottam explain chesi edvachhu kada ee chirigi poyina jacket lo nunchi sagam gaddal kanipinche answers cheppakapothe nee G

[deals2buy]

[quote name='Alexander' timestamp='1349374285' post='1302581941']
Returns the starting position of the specified expression in a character string.
[/quote]

[tom bhayya]

[quote name='charygaru' timestamp='1349374384' post='1302581955']
starting position ki poyi em peekedi untadi ??? ardham aythe mottam explain chesi edvachhu kada ee chirigi poyina jacket lo nunchi sagam gaddal kanipinche answers cheppakapothe nee G
[/quote]
starting position of specified expression antey aa number/string kaadhu charyji.. meeru specify chesina expression ekkada vachindhi ani in this case 0 ekkada vachindhi ani..

[lolliman]

[quote name='Alexander' timestamp='1349374158' post='1302581920']
[img]http://www.desigifs.com/sites/default/files/rt%201%20%283%29.gif?1289984827[/img] lolli baa
[/quote]

endivayyaa raaathri poota ikkade thirugutunnav, morning lechi job ki eppudu velthav inkaa

[lolliman]

[quote name='Alexander' timestamp='1349374122' post='1302581911']
antey vallaithey cheya veseysthaava [img]http://www.desigifs.com/sites/default/files/brahmam_style19.gif?1290059509[/img] chellamaki chepthaa
[/quote]


aa pani cheyyu, appudu choosi, choodakunda peekude peekudu [img]http://www.desigifs.com/sites/default/files/2rc6849.gif?1290170623[/img][img]http://www.desigifs.com/sites/default/files/2rc6849.gif?1290170623[/img]

[charygaru]

[quote name='Alexander' timestamp='1349374517' post='1302581978']
starting position of specified expression antey aa number/string kaadhu charyji.. meeru specify chesina expression ekkada vachindhi ani in this case 0 ekkada vachindhi ani..
[/quote]

0 oka vela aa numbers lo madhyala vasthe appudu ?? naaku only last position la 0 unte ne adi eliminate avvali inkekkada unna ok !! so appudu aa query vaadachha nenu

[tom bhayya]

[quote name='lolliman' timestamp='1349374738' post='1302582007']

endivayyaa raaathri poota ikkade thirugutunnav, morning lechi job ki eppudu velthav inkaa
[/quote]
ippudu office loney vunna kadha rey [img]http://www.desigifs.com/sites/default/files/brahmam13.gif?1290058682[/img]

[padmasri123]

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


instr('ID',0,-1) this gives the POSITION of the 0 in ID and -1 represents the position count starts from last character.

substr('ID',instr('ID',0,-1)) != 0 ---> this gives the value of the instr which not equals to zero.

[lolliman]

[quote name='Alexander' timestamp='1349374891' post='1302582021']
ippudu office loney vunna kadha rey [img]http://www.desigifs.com/sites/default/files/brahmam13.gif?1290058682[/img]
[/quote]

ippudu vunnav, nidra ela saripothadi antunnaa [img]http://www.desigifs.com/sites/default/files/2rc6849.gif?1290170623[/img]

[deals2buy]

[quote name='padmasri123' timestamp='1349374963' post='1302582032']


instr('ID',0,-1) this gives the POSITION of the 0 in ID and -1 represents the position count starts from last character.

substr('ID',instr('ID',0,-1)) != 0 ---> this gives the value of the instr which not equals to zero.
[/quote]

[goli soda]

[quote name='padmasri123' timestamp='1349374963' post='1302582032']


instr('ID',0,-1) this gives the POSITION of the 0 in ID and -1 represents the position count starts from last character.

substr('ID',instr('ID',0,-1)) != 0 ---> this gives the value of the instr which not equals to zero.
[/quote]
oreyyyy cheppesavaa.... nenu ade cheptham anukuntunna...... yee lopu nuvve kanichesavu kada....

[chelsea]

chary garu instr is Pl/sql function slqserver lo char index use cheyyali