Sign in to follow this  
Followers 0
arun_cdm

How to extract data from field of value

2 posts in this topic

Hi all,

In SQL, I want to split the value from a field.

eg: 12345615-11-2010101010

 

In above sample, i want to split the data into 2 parts.

i.e.: 12345615-11-2010101010 ----> Actual getting data

 

(123456)-(15-11-2010101010) --> To be splited

Part-1 & Part-2

 

The first & second part of data is not an exact size, i may vary.

 

How to split the data into two parts.

 

Note: am using SQL server 2005 std edition.

0

Share this post


Link to post
Share on other sites

Hi all,

In SQL, I want to split the value from a field.

eg: 12345615-11-2010101010

 

In above sample, i want to split the data into 2 parts.

i.e.: 12345615-11-2010101010 ----> Actual getting data

 

(123456)-(15-11-2010101010) --> To be splited

Part-1 & Part-2

 

The first & second part of data is not an exact size, i may vary.

 

How to split the data into two parts.

 

Note: am using SQL server 2005 std edition.

 

You need to create your own Scalar-valued function to be able to meet your requirements.

0

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0