Microsoft KB Archive/103142

SQL Server String Funcs Supported by the Connectivity Kit ID: Q103142 The information in this article applies to: Microsoft FoxPro Connectivity Kit for Windows, version 2.5 Microsoft FoxPro Connectivity Kit for MS-DOS, version 2.5 SUMMARY The Microsoft FoxPro Connectivity Kit can be used with FoxPro versions 2.5 and 2.5a for MS-DOS and Windows. The FoxPro Connectivity Kit, and the Open Database Connectivity (ODBC) specification in general, supports the minimum ANSI SQL standard. Below is a list of the SQL string functions that are supported. MORE INFORMATION The following table lists the supported string-manipulation functions. IMPORTANT: Any character string passed as an argument to one of these functions MUST be enclosed in SINGLE quotation marks. Parameter arguments listed as STRING_EXP can be character-type columns, strings, or character results from another function call. Parameter arguments listed as START, LENGTH, CODE, or COUNT must be numeric values. Function Description ------------------------------------------------------------------ ASCII(string_exp) Returns the ASCII code value of the leftmost character of STRING_EXP. CHAR(code) Returns the character that has the ASCII code Value specified by CODE. CONCAT(string_exp1,string_exp2) Returns a character string that is the result of concatenating STRING_EXP1 with STRING_EXP2. INSERT(string_exp1,start,length Returns a character string where string_exp2) LENGTH characters have been removed from STRING_EXP1 beginning at START and where STRING_EXP2 is then inserted in STRING_EXP1, starting at START. LCASE(string_exp) Converts all uppercase characters in STRING_EXP to lowercase. LEFT(string_exp,count) Returns the leftmost COUNT characters of STRING_EXP. LTRIM(string_exp) Returns STRING_EXP with no leading blanks. LENGTH(string_exp) Returns the number of characters in STRING_EXP, excluding trailing blanks and the string-terminator characters. LOCATE(string_exp1, Returns the first starting position string_exp2 [,start]) of STRING_EXP1 within STRING_EXP2. If START is specified, the search begins at character START of STRING_EXP2. REPEAT(string_exp,count) Returns a string consisting of STRING_EXP repeated COUNT times. REPLACE(string_exp1,string_exp2, Replaces all occurrences of string_exp3) STRING_EXP2 in STRING_EXP1 with STRING_EXP3. RTRIM(string_exp) Returns STRING_EXP with no trailing blanks. SUBSTRING(string_exp,start, Returns a substring of STRING_EXP length) starting at length position START that is LENGTH characters long. UCASE(string_exp) Converts all lowercase characters in STRING_EXP to uppercase. REFERENCES Microsoft Open Database Connectivity Software Development Kit (SDK) "Programmer's Reference," version 1.0, pages 526-527 Additional query words: FoxWin FoxDos CK 2.50 ODBC Keywords  : Version  : Platform  : Issue type  :

Last Reviewed: August 20, 1999 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.