JavaScript does not offer Left and Right functions. Use the following functions to extract the left or the right part of a string. function Left(str, n){ if (n String(str).length) return
This tip explains how to pass an object to a JavaScript function and retrieve the values from the “this” object. See the following piece of code: click… Run the above
‘ Compares a numeric or string value with a list of other values.’ Returns the 1-based index of the matching value, or zero if the’ value doesn’t appear in the
‘ Returns a formatted string that shows the size in Bytes, KBytes or MBytes’ according to the size’ Usage:’ Dim ProperSizeString As String = FormatSize(“132100842”)’ -> returns “125.98 MB”Function FormatSize(ByVal
This functionality is not currently available in Javascript. However, tou can add this function to perform trimming in the strings. Trimming is useful in checking for empty spaces. function RTrim(str){
This code allows any image to be used as a background, and scales that image to fit the browser. Just add it to the end of your HTML page:
This is an advanced solution to delete duplicate Rows from a table using the cursor: create table DupTable ( Field1 varchar(20))goinsert DupTable (Field1) select ‘A11111111’ UNION ALL select ‘B22222222’ UNION
BCP is a command line tool that allows you to obtain data quickly, whether that data is in or out of a database or tables. The script below uses an
Using the IDENTITY function, you can add a Record number to an existing table.For Example: select * from addresscity state zip contract——————– —– —– ——–Lawrence KS 66044 0Nashville TN 37215