Replace Null Snippets


05 November, 2015   

MYSQL code sample to replace a NULL with a given value.

This stored sql procedure is used to replace a special character (or string) of your field with another string.

25 August, 2014   

The function NVL replaces null values with a stated value. In this example the rc.customer is assigned the number '0' if it is null.

Does url_decoding while respecting utf8 characters.

Does url_decoding while respecting utf8 characters.

23 November, 2013   

You can search and replace fields by below query in MySQL Database

11 August, 2012   

MySQL code to find and replace string

22 June, 2014   

To test in other timezones, replace '-5' with your local standard time GMT offset.

18 June, 2012   

An example of Stored PL/SQL blocks

30 October, 2013   

Find a key from a list of values​​. parameters: sbValues​​: List of Values 'A;B;C;D' sbToken: Key 'B' sbSeparator: ',' or any defined sbValues

13 December, 2011   

You can use to find and replace text in a variable. This script created by Bruce Phillips, one of the leading posters at MacScripter.

08 September, 2012   

SQL query to know employees where city is null

Using a stored procedure as the source in an OLE_DB Source for SSIS, the package can’t detect the output of the stored proc.

01 October, 2014   

PHP example code for secure link conversion

01 February, 2011   

Missing images will either just display nothing, or display a [ ? ] style box when their source cannot be found. Instead you may want to replace that with a "missing image" graphic that you are sure exists so there is better visual feedback that something is wrong. Or, you might want to hide it entirely. This is possible, because...

07 February, 2011   

If you don't set the wmode on a flash embed it will float over the top of an overlay which can be a pretty big deal. This is ideal in environment with lots of legacy video code or where users will be posting new code and teaching them about wmode is a lost cause. This should work in all browsers.

17 February, 2019   

Missing images will either just display nothing, or display a [ ? ] style box when their source cannot be found. Instead, you may want to replace that with a "missing image" graphic that you are sure exists so there is better visual feedback that something is wrong. Or, you might want to hide it entirely. This is possible because...

Several hundred user notes on the str_replace page later, and we have a function that provides a variety of text highlighting options for plaintext or HTML strings.

29 April, 2013   

Saving the IP as Int we save a lot of space and permit do beautiful selects

15 February, 2015   

Move field position while still retaining its content.