Jump to content
Sadikhov IT Certification forums
Sign in to follow this  
arun_cdm

How to extract data from field of value

Recommended Posts

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.

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.

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  

×