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...
-
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... -
Today We are going to learn how we can create a git repository using android studio. Android Studio Makes it very simple just follow the be... -
Problem : Display data horizontally in Crystal report . If you Want to display horizontally data in crystal report you can use Multiple co...
No comments:
Post a Comment