Hi !!
One of the fields in my Table is DETAILS.
I need to build a query in which The DETAILS field should only reflect characters starting from 1 upto the first blank space it encounters.
eg.
Details field is "DAWAHI AL NABA TRADING-123" ... it should extract and display "DAWAHI"
Details field is "KHIMJI RAMDAS - 3050365871" ... it should extract and display "KHIMJI"
Details field is "INBB22060028 - WATERFRONT" ... it should extract and display "INBB22060028"
Any help would be appreciated.
Thx!