During my Development i found a situation where i have to separate string on '|' basis for acheiving this i wrote following small query
select
SUBSTRING(('KHI|108'),0,CHARINDEX('|',('KHI|108'))) City ,
REVERSE(SUBSTRING(REVERSE('KHI|108'),0,CHARINDEX('|',REVERSE('KHI|108')))) CityCode
Subscribe to:
Post Comments (Atom)
Postman beginner Tutorial
Hi , I have started new video series of postman tutorial hope it will be helpful:Please give me your feed back in comments and like and sub...
-
this app is not collecting any users data
-
after 30mins of struggle i found a solution:) 1)Click on Layout Button. 2)Click on Edit HTML. 3) Now, in code given below go at the botto... -
I have to display amount in Words with decimal values in my report for achieving this i wrote small formula in Crystal Report here is the...
No comments:
Post a Comment