Select any particular Alphanumeric values from a column in MS Access:
From above scenario , i am just fetching BX values with numeric digits. Like 1000BX,6BX and etc.. Execute the below code and face the desire output. SELECT F1, Mid(F1,4,Instr (F1, "BX")-2) FROM tk WHERE F1 Like '*[0-9]BX*';
No comments:
Post a Comment