SQLServerCentral / Discuss Content Posted by Nagabhushanam P / Article Discussions / Article Discussions by Author

LPAD Function

Bhushan — Fri, 05 Oct 2007 04:06:20 GMT

Comments posted to this topic are about the item [B]LPAD Function[/B]

Initcap Function

Bhushan — Fri, 12 Oct 2007 18:17:45 GMT

Comments posted to this topic are about the item [B]Initcap Function[/B]

Why does this code produce error when Field length is 0

awheeler_01 — Thu, 07 Oct 2010 12:33:24 GMT

The code is:=IIF(Len(Fields!Academic.Value)> 0, Left(Fields!Academic.Value,InStr(Fields!Academic.Value, "(") - 1), "")which produces and error.If I change the code to =IIF(Len(Fields!Academic.Value)> 0, Fields!Academic.Value, "") there is no error. I want to display only the characters before ")" character if the field has a value otherwise nothing. Seems simple enough but ...any ideas.

Using Built in Functions in User Defined Functions

Bhushan — Sun, 13 Jul 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/nagabhushanam/usingbuiltinfunctionsinuserdefinedfunctions.asp

Initcap has a bugs

matteo.sangiorgio — Wed, 21 Jan 2009 08:42:26 GMT

Try to use the function with this script:select dbo.Initcap('Test with ( special char ) ')

SPLIT Function

Bhushan — Sat, 13 Oct 2007 18:45:17 GMT

Comments posted to this topic are about the item [B]SPLIT Function[/B]

SUBSTR - SUBSTRING function extension

Bhushan — Sat, 13 Oct 2007 15:46:57 GMT

Comments posted to this topic are about the item [B]SUBSTR - SUBSTRING function extension[/B]

RPAD Function

Bhushan — Sat, 13 Oct 2007 15:28:10 GMT

Comments posted to this topic are about the item [B]RPAD Function[/B]

INSTR Function

Bhushan — Sat, 13 Oct 2007 12:43:48 GMT

Comments posted to this topic are about the item [B]INSTR Function[/B]