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

SUBSTRING(('KHI|108'),0,CHARINDEX('|',('KHI|108'))) City ,

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