Wednesday, April 13, 2011

Separate Strings in SQL Server

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

No comments:

Post a Comment

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 ...