var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: this is new to me
This is new to me so please excuse my ignorance.
I have a field of comma delimited digits and i want to find out if a digit exists in the string.
how can i query this so it will make a recordset if i search for "1" but wont for feilds containing "10" or "21".
I hope this makes sense.
which database do you use ? This would be very helpful
If you only want to find a comma in a string use
for ORACLE => SELECT INSTR('10,20,30,40', ',')
if the comma is found it returns the position otherwise it return 0
Hope that helps ?
this is microsoft access. soon i will be developing in MySQL.
I know VBscript well enough. but i'm testing for the number not the comma. and Instr() would return a value greater than zero for too many results.
perhaps i just filter them out.
thanks for your help