Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL puzzle
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL puzzle
Miscellaneous
Thread ID:
00681325
Message ID:
00681325
Views:
47
I think this may qualify as a SQL puzzle.

I have a table with a memo field containing a 2K write-up.
I have several target strings which may exist in the write-up.
Using a SELECT statement like the following I can collect a sub-set of records to examine more closely
SELECT * ;
	FROM Profiles ;
	INTO TABLE C:\TEMP\Temp ;
	WHERE Profiles.date_enter > DATE()-60 ;
		AND NOT EMPTY(Profiles.write_up) AND ;
		(cString01 $ Profiles.write_up ;
		OR cString02 $ Profiles.write_up ;
		OR cString03 $ Profiles.write_up ;
		OR cString04 $ Profiles.write_up)
Puzzle: I want to find out how many target strings exist in each record, so I can take a closer look at those records records.

I suppose I could run a scan loop and counters...but is there another (hopefully better) way?

Rick
Next
Reply
Map
View

Click here to load this message in the networking platform