Right Substring in SQL Server

telldurg...

Hello Team,

I want right substring from sql how can i get the result

Example i have a string 'ABCDEFGHIJK'

I WANT FROM RIGHT ' EFG ' HOW CAN I GET

its dynamic like substring we give (length,start,position)

like this i want from right we can give dynamic number from right.

dharmend...

0 3

Hi telldurges,

Use REVERSE function.

SQL

SELECT REVERSE(SUBSTRING(REVERSE('ABCDEFGHIJKL'),6,3))

Output

EFG

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html