SQL BUILT IN FUNCTIONS PART – 2 In my last SQL BUILT IN FUNCTION ARTICLE ASCII & CHAR has been described, today the REPLACE system function provides the functionality of replacing all occurrences of a given value with another value. This system function is valuable for masking processes. If the value...
SQL BUILT IN FUNCTIONS PART –1 The ASCII and CHAR system functions provide the conversion functionality between character values and ASCII code values. These system functions are valuable when iterating through characters, mathematically determining characters and randomly deriving characters. The American...
Posted to
Rahul Kumar Ghosh's Blog
by
rahul kumar ghosh
on
07-19-2011
Filed under:
Filed under: ASCII, master..spt_values, CHAR, DATA TYPE, DATATYPE, TEMPORARY TABLE, SUBSTRING, WHERE, TABLE, SELECT, BRH
I’ve been working lots of hours lately because our project is just about to go into production. One of my ETL processes has gone through many changes recently because business users are now very actively sending us their late minutes requirements. After making some changes to my ETL process, and re-loading...