Can i Use Like with Wildcard where i do not speciy any characters but just Wildcard match Format
From Table1 Where Field1 like '?????-????-*' ;
in the above example the the Patterns which i Need to load must be something like ghfds-fdsd-sdds or dsasdf-fgds-sd
The table contains more than 50000 rows. this Special pattern which has 5 characters in the begining and then a '-' 4 characters and then '-' and followed by any characters. This pattern indicates a product category. so i want to load this pattern.