Aug 1, 2011

How to Get splited string from value

SELECT SUBSTRING(REPLACE(InsuFromDate,'/',''), 0, CHARINDEX('/',InsuFromDate)) AS a,
SUBSTRING(REPLACE(InsuFromDate,'/',''), CHARINDEX('/',InsuFromDate), CHARINDEX('/',InsuFromDate)) AS b
from MHCControlParameterCar
By

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

What is the use of n-tier architecture and 3-tier architecture?

how to implement 3-tier architecture in asp.net using c#. 3-Tier architecture is also called layered architecture. Some people called it ...