sql doubt -- gali n rowdy

[htnamus]

select circuitID , date, ... from table where ....


Circuit ID values emo
123456  [name]
673378  [name]
.
.
.
ani ostunnai ,
naku aa [name] oddu ..ela truncate cheyali dani ..em chesina a select statement lo ne cheyali
CITI#H@ CITI#H@ CITI#H@

[nenuinthe]

crrct ga Query PM cheyyi okka mukka ardam ithe cheppichukuni kottu  @3$% @3$%

[nenuinthe]

naku ardam ayyina dani batti ne result


123HS
456Rowdy


ani vastandi kani niku

123
456

ani ravali ..antena...ala ithe 123,456 prati row lo fixed lenght means three digit matrame untaya

[htnamus]

[quote author=BEZAWADA ROWDY link=topic=245404.msg3072376#msg3072376 date=1317659557]
crrct ga Query PM cheyyi okka mukka ardam ithe cheppichukuni kottu  @3$% @3$%
[/quote]sent  :0012391: :0012391: :0012391:

[gvkishore.kish]

[quote author=BEZAWADA ROWDY link=topic=245404.msg3072376#msg3072376 date=1317659557]
crrct ga Query PM cheyyi okka mukka ardam ithe cheppichukuni kottu  @3$% @3$%
[/quote]

@gr33d @gr33d @gr33d @gr33d

naku kuda PM pettu baa try cehstaaaa H&*() H&*() H&*() H&*()

[htnamus]

[quote author=BEZAWADA ROWDY link=topic=245404.msg3072393#msg3072393 date=1317659737]
naku ardam ayyina dani batti ne result


123HS
456Rowdy


ani vastandi kani niku

123
456

ani ravali ..antena...ala ithe 123,456 prati row lo fixed lenght means three digit matrame untaya
[/quote]ledu konni 123 unte ..inko 12345 ala length vary authundi

[Ranga_The_Donga]

SELECT  circuitID , date, .. FROM table WHERE IsNumeric(circuitID) = 1

try that....

[galigannarao]

[quote author=HS link=topic=245404.msg3072364#msg3072364 date=1317659413]
select circuitID , date, ... from table where ....


Circuit ID values emo
123456  [name]
673378  [name]
.
.
.
ani ostunnai ,
naku aa [name] oddu ..ela truncate cheyali dani ..em chesina a select statement lo ne cheyali
CITI#H@ CITI#H@ CITI#H@
[/quote]numberki nameki space unte kanuka space index techukoni substring chesi padey simple

[Achilles_afdb]

chepparu  &D_@@ &D_@@

[htnamus]

[quote author=galigannarao link=topic=245404.msg3072410#msg3072410 date=1317659888]
numberki nameki space unte kanuka space index techukoni substring chesi padey simple
[/quote]space annitlo undo ldo kani [b][[/b] matram undi  aa substring edo ela cheyalo chepu

[htnamus]

[quote author=Jeedeelu link=topic=245404.msg3072407#msg3072407 date=1317659864]
SELECT  circuitID , date, .. FROM table WHERE IsNumeric(circuitID) = 1

try that....
[/quote]kani na circuit ids anitlo name include aindi ..naku name okati truncate avali

[K.A.Paul]

naku vochu ..nenu chepakudadaaa Dr@w@ Dr@w@

[Ranga_The_Donga]

[quote author=HS link=topic=245404.msg3072424#msg3072424 date=1317660038]
kani na circuit ids anitlo name include aindi ..naku name okati truncate avali
[/quote]

adhi try chesthe...


nee result set lo only numbers display avuthayi......it wont show names....

[htnamus]

[quote author=K.A.Paul link=topic=245404.msg3072429#msg3072429 date=1317660080]
naku vochu ..nenu chepakudadaaa Dr@w@ Dr@w@
[/quote]cheppu nayinoooooooooooo  cry@fl cry@fl cry@fl

[htnamus]

[quote author=Jeedeelu link=topic=245404.msg3072432#msg3072432 date=1317660115]
adhi try chesthe...


nee result set lo only numbers display avuthayi......it wont show names....
[/quote]na circuit IDs ila untai

34.LXFU.401274..SB [AT&T]
nu chepinatu aithe aa LXFU dobbuddi ga