Query not returning distinct value

[miniThomas]

Hi, I am firing a query as "select distinct(trim(opp_name)) from tblOpps" but this query returns ============ Renewal Services Renewal New I want Renewal to appear only once not twice Thnaks, Mini

[ritu4321]

there is nothing as trim in sql query. Try removing trim you will get the result.

[randz]

i agree with ritu4321. but if you intend to remove trailing or preceding space, you can use rtrim or ltrim. But please note that ltrim and rtrim does not remove extra spaces within the string, only those at the beginning (for ltrim) and those at the end (for rtrim). Hope this helps.

Remember, your work is not yours alone. Somewhere, there are some codes written by others amongst us that depends on your work. By failing to see that you are part of their ecosystem, you are bound to break their code.

[Michael Potter]

DISTINCT should be used as a SELECT operator, not as a function. I also do not know where you get the trim() function from.

SELECT DISTINCT
    LTRIM(RTRIM(opp_name))
FROM
    tblOpps

[Frank Kerrigan]

if you get stuck try and use the len (length function) sometimes using or importing unicode string (nvarchar etc) can cause issues. SELECT DISTINCT LTRIM(RTRIM(opp_name)), len(opp_name), len(LTRIM(RTRIM(opp_name))) FROM tblOpps

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http://www.frankkerrigan.com/[^]