Substring Sql Substring SQLSQL-function SUBSTRING can be used in applications, Delphi, working with queries to the local SQL, but it is not supported when working with tables Inter Base (IB) and the Local Inter Base Server (LIBS). Below is the syntax of the function SUBSTRING, examples of its use in queries to the local SQL, and an alternative to return the same results for the tables IB / LIBS. Syntax of function SUBSTRING: SUBSTRING ( FROM [, FOR ]) Where: - the name of the column of the table, from which must be received by the substring sql(substring). place within the meaning of the columns from which to extract a substring. length extracted substring. SUBSTRING function in the following example returns the second, third and fourth characters of the column named COMPANY: SUBSTRING (COMPANY FROM 2 FOR 3) SUBSTRING function can be used to list the fields in the SELECT-query, where the keyword WHERE allows comparison of the value with a set of speakers. SUBSTRING function can only be used with columns of type String (in SQL type CHAR). Here is an example of function SUBSTRING, using a list of columns in the SELECT-query (use the demo table Paradox CUSTOMER. DB): SELECT (SUBSTRING (C. Substringsql.com~Site InfoWhoisTrace RouteRBL Check
