On Mon, 15 Oct 2007 07:29:05 -0700, Ryan Mcbee wrote:
I am writing a query in which I want to select a field and not have the
trailing blank spaces. Here is my query: select employid, lastname + ',' +
frstname as name from upr00100
The results look like this "West ,Paul" or "Mcbee
,Ryan"
How can I get results to look like "West,Paul" or "McBee,Ryan"?
Hi Ryan,
SELECT employeeid, RTRIM(lastname) + ',' + firstname AS name
FROM upr00100;
Re: SQL Humor ...Hugo Kornelis wrote: ...SQL Server will often produce the same execution for both versions. ... the big questions for the RM, *for me* seem to include view updatability which has to do with the operators of the algebra as well as whether a relational engine can implement customary features such as concurrency control and presentation coherence without being written in a language that eschews the relational operators.... (comp.databases.theory)
Re: Help with missing data in query ... I did go to that site But I couldn't figure out how to upload anything. ... GROUP BY m.MonthName WITH ROLLUP...Hugo Kornelis, SQL Server MVP... (microsoft.public.sqlserver.mseq)
Re: How to Gnerate a Random ID Number ... formula with a seed as input to get at a pseudo-random value?) ... that definitely rules out newid() as a "good" pseudo random number ... this on SQL Server 2005, and the seed does not seem to be reset (or at ...Hugo Kornelis, SQL Server MVP ... (comp.databases.ms-sqlserver)
Re: Not passing back values on an if statement ...Hugo Kornelis wrote: ...SQL Server has to check not only that a row ... > column Application doesn't allow NULLs,... This email account is my spam trap so I ... (microsoft.public.sqlserver.programming)
Re: mssql: insert into syntax ...Hugo Kornelis writes: ... > Your mention of preserving order when rows are deleted makes me think ... INSERT tbl... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... (comp.databases.ms-sqlserver)
