SQL string manipulation

String manipulation samples that frequently would be in the client or server scripting environment. Implemented here as sql functions. The functions are then used as columns in the Select and where clause.
 
Array Scan...

Array Scan

  • Select a delimiter, string, array item.
  • As you select the items the string is scanned as an array.
  • The string value at the selected position is displayed.

Delimiter
String
Item Number
Result
Value at Item: MNO
Is Email Valid
Pad a String
Convert Seconds to DD-HH-MM-SS

Michael W Stark

Software Developer

.Net 3.5
SQLServer 2005 2008

Rich Interface Design

Rapid Development

Flash

My Work

SQL Samples