"Any WHERE clause that checks if column_name = NULL will return no rows, such as in this example."

Not needs qualified to include considering setting ANSI_Nulls

create table #TestIt(MyValue Char(1), MyNullValue char(1))

insert...

dwain.c (1/21/2013)

---

tyson.price (1/21/2013)

---

Any old CICS mainframe programmers here remember calling a deadlock a "deadly embrace"? That wasn't limited to just databases, which were relatively new in my environment (we...

dwain.c (1/21/2013)

---

tyson.price (1/21/2013)

---

Any old CICS mainframe programmers here remember calling a deadlock a "deadly embrace"? That wasn't limited to just databases, which were relatively new in my environment (we...

Any old CICS mainframe programmers here remember calling a deadlock a "deadly embrace"? That wasn't limited to just databases, which were relatively new in my environment (we were still...

GSquared (11/6/2012)

---

Does your data take "leap seconds" and things like that into account? There have been several over the last 42 years. They don't matter to very many...

Here is another example from here:

http://blog.sqlauthority.com/2007/08/22/sql-server-t-sql-script-to-insert-carriage-return-and-new-line-feed-in-code/

DECLARE @strPrint VARCHAR(100);

SET @strPrint = 'Example of carriage return';

SET @strPrint = @strPrint + CHAR(13);

SET @strPrint = @strPrint + 'SQLAuthority.com';

PRINT @strPrint;

GO

PRINT '---------------------------------'

DECLARE @strPrint VARCHAR(100);

SET...

A little bit down in this post is one example and a link to something someone said is better.

http://www.sqlservercentral.com/Forums/Topic1366387-338-1.aspx

Here is the function in that link:

SET ANSI_NULLS ON

GO

SET...

Along the lines of what GilaMonster said I pass strings that I need to use in "Where in" quite a bit. This is what I use:

I have this funciton...

Good tip...I always right clicked on the results pane and selected copy with headers.

The OP asked four years ago so maybe he/she picked up on it by now 😀

I get your point but, that is why we have comments. I will take performance over easy to read any day of the week. Comments are easy to type and...

Luis Cazares (8/24/2012)

---

tyson.price (8/24/2012)

---

Most programmers would need to research what "'%[^'+@Char+'X]%'" means if they came across it supporting code. Why put that in place when something much more readable...

Eugene Elutin (8/24/2012)

---

Steven Willis (8/24/2012)

---

Try this:

CREATE FUNCTION dbo.svfRemoveLeftMostCharacters

(

@Source VARCHAR(1000)

,@Char CHAR(1)

)

RETURNS VARCHAR(1000)

AS

BEGIN

/* This function requires a Tally or Numbers table */

/*

You didn't specify, other than by the eaxmple, but this will just eliminate leading zeros.

select...

What I ended up doing just for expediency’s sake is:

In the select:

,'GR' + convert(Varchar,t1.pkRate_Barcodes) 'ac2'

,'GR' + convert(Varchar,t2.pkRate_Barcodes) 'ac26'

,'GR' + convert(Varchar,t3.pkRate_Barcodes) 'GrpRatCont'

,'GR' + convert(Varchar,t4.pkRate_Barcodes) 'EnrollQuest'

,'GR' + convert(Varchar,t5.pkRate_Barcodes) 'EnrollQuestInv'

,'GR' + convert(Varchar,t6.pkRate_Barcodes) 'U-153'...