ASP DOT NET

Saturday, June 9, 2018

Q. How to remove first and last letter from particular column using sql server?
Ans.
Select LEFT(RIGHT(Inv_No, len(Inv_No)-7),len(Prof_Inv_No)-13) as Inv_No from Invoice_Details
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...