For example: a database field name "AA", the following content is: abc# def# this form, with a separator "#", how to use a select statement to take out the ABC, and displayed on the DataGrid1,

CodePudding user response:

Select the left (aa, instr (aa, "#")) as newaa from the table

CodePudding user response:

Mid function # judgment can subcontract to solve data

CodePudding user response:

This is a problem in the design of the database, need separate processing of information, in advance, must be separated in different fields, on the code a little later, will greatly reduce the efficiency of database query,

CodePudding user response:

reference of123 reply: 3/f

this is a problem in the design of the database, need separate processing of information, in advance, must be separated in different fields, on the code a little later, will greatly reduce the efficiency of database query,

The truth!

Irregular data with any database!