String functions not working in stored procedure in SQL

Question

I have written code for stored procedure

ALTER PROCEDURE dbo.Store_Reviews_GetByProduct
    @PortalID int,
    @ProductID int

    AS
    SET NOCOUNT ON

    SELECT r.ReviewID, r.PortalID, r.ProductID, r.UserName, r.Rating, LEFT(r.Comments,200), r.Authorized, r.CreatedDate, p.ModelName
    FROM dbo.Store_Reviews r
        LEFT JOIN dbo.Store_Products p
            ON r.ProductID = p.ProductID
    WHERE r.PortalID = @PortalID
    AND r.ProductID = @ProductID
    ORDER BY r.CreatedDate DESC

In that the LEFT function is not working, instead it gives no results or select none.

I have used Substring function as well like SUBSTRING(r.comments, 0, 200) but it also gives no result.

How can I get first 200 characters of comments column??

All answers are appreciated..

SQL isn't my strong suit, but you might need to alias the result of the string function for it show up reliably in your results. — Tieson T.
– Tieson T., Commented Aug 17, 2013 at 6:01
Can't reproduce - works just fine on e.g. the AdventureWorks sample DB.... — marc_s
– marc_s, Commented Aug 17, 2013 at 6:36
I don't think LEFT() is the issue. Does it return the entire content of comment if you remove it? — Mikael Eriksson
– Mikael Eriksson, Commented Aug 17, 2013 at 7:18
Does this also fail in Management Studio, or only in your client program? — RBarryYoung
– RBarryYoung, Commented Aug 21, 2013 at 20:32

Ehsan · Accepted Answer · 2013-08-17 06:21:44Z

1

this works fine as well

SUBSTRING(r.comments,1 ,200)

answered Aug 17, 2013 at 6:21

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

String functions not working in stored procedure in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related