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...
-
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... -
I have to add Image in one of my project in slider Menu , I have used Android Studio Template Navigation Drawer for material design . For... -
I have to convert amount into words like 2150 to two thousand and fifty only . for achieving this i have used towords() function in crystal...
No comments:
Post a Comment