Coldstreamer Posted 4 December , 2006 Share Posted 4 December , 2006 Any one know why you cant do wild card searches any more ? Link to comment Share on other sites More sharing options...
Stebie9173 Posted 4 December , 2006 Share Posted 4 December , 2006 I can't remember there being a wildcard. I just stop before the awkward bits and it gives me a selection.... Steve. Link to comment Share on other sites More sharing options...
Coldstreamer Posted 4 December , 2006 Author Share Posted 4 December , 2006 perhaps its me going mad ? Link to comment Share on other sites More sharing options...
Gary Samson Posted 4 December , 2006 Share Posted 4 December , 2006 perhaps its me going mad ? Could be! The wildcard character '%' worked for me not ten seconds ago. Gary Link to comment Share on other sites More sharing options...
Terry Denham Posted 4 December , 2006 Share Posted 4 December , 2006 Yup! It still works. Link to comment Share on other sites More sharing options...
Coldstreamer Posted 4 December , 2006 Author Share Posted 4 December , 2006 Thanks Didnt know you used % Link to comment Share on other sites More sharing options...
Gary Samson Posted 4 December , 2006 Share Posted 4 December , 2006 Thanks Didnt know you used % Curious. Just out of interest what character were you using for wildcard searches that worked up until recently but no longer? Gary Link to comment Share on other sites More sharing options...
Coldstreamer Posted 4 December , 2006 Author Share Posted 4 December , 2006 ** - thats what I always use on wildcards Link to comment Share on other sites More sharing options...
Gary Samson Posted 4 December , 2006 Share Posted 4 December , 2006 ** - thats what I always use on wildcards For SQL queries on databases '%' (which means match to any number of characters in this position) is normally used as a wildcard character. The underscore character '_' means match to any single character in this position. Both of these work on the CWGC website. Gary Link to comment Share on other sites More sharing options...
John_Hartley Posted 4 December , 2006 Share Posted 4 December , 2006 Didnt know you used % Me, neither. But it explains how Terry managed to find a chap of mine called Chevalier was really Le Chevalier. Practitioners of the black arts are at work here, my friends. John Link to comment Share on other sites More sharing options...
Terry Denham Posted 4 December , 2006 Share Posted 4 December , 2006 John You are wrong there but the end result is the same! Link to comment Share on other sites More sharing options...
John_Hartley Posted 4 December , 2006 Share Posted 4 December , 2006 Link to comment Share on other sites More sharing options...
Coldstreamer Posted 5 December , 2006 Author Share Posted 5 December , 2006 For SQL queries on databases '%' (which means match to any number of characters in this position) is normally used as a wildcard character. The underscore character '_' means match to any single character in this position. Both of these work on the CWGC website. Gary cheers for the info Gary Link to comment Share on other sites More sharing options...
Max Posted 5 December , 2006 Share Posted 5 December , 2006 For SQL queries on databases '%' (which means match to any number of characters in this position) is normally used as a wildcard character. The underscore character '_' means match to any single character in this position. Both of these work on the CWGC website. Gary The character * can also be used as a wildcard, it just depends what the dayabase is and what type of script is being used to access it. Andy Link to comment Share on other sites More sharing options...
Gary Samson Posted 5 December , 2006 Share Posted 5 December , 2006 The character * can also be used as a wildcard, it just depends what the dayabase is and what type of script is being used to access it. Andy Of course. Microsoft Jet SQL, for example, uses '*' and '?' but if you aren't sure of the database architecture then I find it's generally better to start with ANSI SQL ('%' and '_') then try vendor-specific variants. Gary Link to comment Share on other sites More sharing options...
Max Posted 5 December , 2006 Share Posted 5 December , 2006 Of course. Microsoft Jet SQL, ..and informix Link to comment Share on other sites More sharing options...
Coldstreamer Posted 5 December , 2006 Author Share Posted 5 December , 2006 amazing the info you get - and its not all WW1! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now