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)
Asp Classic Upload File Issue
Recently I have migrated asp classic application from old server to new server . I found file upload is not working in new IIS 7 Server . I ...
-
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... -
sudo ionic build android [Error: ANDROID_HOME is not set and "android" command not in your PATH. You must fulfill at least o...
-
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...
No comments:
Post a Comment