A common need in SQL is the ability to iterate over a list as if it were an array. In SQL it is not possible to declare arrays, unlike other programming languages such as ColdFusion, ActionScript and Java. Fortunately, there is a way around this problem: use a User-Defined Functions (UDFs) to create a tabular version of the data. Arrays are, after all, essentially tabular data (at their simplest, one dimension level).
Tags: ActionScript, array, data, database, database server, extend, function, Java, SQL, sub-routine, subroutine, t-sql, tabular, UDF, user defined function
The SQL Replace function enables us to look for a certain character phrase in a string and replace it with another character phrase. The updated string is then returned by the function.
Tags: database, database server, extend, fairly straight forward, function, Microsoft, Oracle, SQL, sub-routine, subroutine, t-sql, UDF, user defined function
British web compliance expert, Magus, joins forces with BSI to raise online standards.
Tags: Accessibility, brand, British Standards, British Standards Institute, compliance, effectiveness, function, Industry, legal, Magus Ltd, online brands, online performance, organisational web standards, PAS 124, Performance, Publically Accessible Standard, search engine, search engine optimisation, SEO, The Web, Web, web accessibility initiatives, web compliance experts, Web Compliance Following, web presence, Web Standards, website