Question: I have two records of this data: I want this in MS SQL

```
03/28/2018^10/22/2018 
02/29/2018^10/28/2018^12/06/2019

```

I want to get right string data after ^. My output should be...

```
10/22/2018 
12/06/2019

```

If i have data 

```
test1^test2^test3^test4  
test5  
test6^test7  
null  

```

output should be 

test4  

 test5  

 test7  

 null

Answer: 
The easiest approach may be to just take the 10 rightmost characters:

```
SELECT RIGHT(mycol, 10)
FROM   mytable

```
You can use `right()` and `charindex()`:

```
select right(str, charindex('^', str + '^') - 1)
from (values ('02/29/2018^10/28/2018^12/06/2019')) v(str)

```