<html><head></head><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1503077579332_42021">i found the solution:</div><div id="yui_3_16_0_ym19_1_1503077579332_42019"><br></div><div id="yui_3_16_0_ym19_1_1503077579332_42020"><br></div><div id="yui_3_16_0_ym19_1_1503077579332_42014" dir="ltr"><span id="yui_3_16_0_ym19_1_1503077579332_42101">my $n = 33;<br id="yui_3_16_0_ym19_1_1503077579332_42088"></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_42121"><span id="yui_3_16_0_ym19_1_1503077579332_42101"><br></span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_42120"><span id="yui_3_16_0_ym19_1_1503077579332_42101">my $foo_rs = $schema<br id="yui_3_16_0_ym19_1_1503077579332_42095"> ->resultset('Test')<br id="yui_3_16_0_ym19_1_1503077579332_42096"> ->search<br id="yui_3_16_0_ym19_1_1503077579332_42097"> ({<br id="yui_3_16_0_ym19_1_1503077579332_42098"> col1 => { like => '%.'.$n }<br id="yui_3_16_0_ym19_1_1503077579332_42099"> })->count;</span></div><div dir="ltr" id="yui_3_16_0_ym19_1_1503077579332_42100"><span></span></div> <div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"><font size="2" face="Arial"> On Friday, August 18, 2017 2:35 PM, Rajeev Prasad <rp.neuli@yahoo.com> wrote:<br></font></div> <br><br> <div class="y_msg_container"><div id="yiv5505547731"><div><div style="color:#000;background-color:#fff;font-family:Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px;"><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_20972" dir="ltr">before i go an do some operations. i need to know if the following will work?<br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_24458"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_24459">so I have this column:</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_21041"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22688">col1</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22825">23.33</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22689">23.46</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22824">12.33</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22701">10.33</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22690">23.546</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22700">23.1</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22691">1.33</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22692">100.33<br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22693"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22694">I want to run two queries</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22695"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22696">1. select all rows with 23 before decimal (not *23.*, just 23.*).</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27847"><br></div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27846">my @foo = $schema</div> ->resultset('Test')<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27815"> ->search<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27816"> ({<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27817"> col1 => { like => 23'.%'}<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27818"> });<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27819"> <br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27820"><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27828">print "values @foo\n";</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_27831"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22823"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22865">I expect:</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22774">23.33</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22775">23.46</div>23.546<div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22779">23.1</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_24455"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22698">2. second i want to run query to select for given value after decimal.</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22811">my $foo_rs = $schema->resultset('Table')->search({<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22812"> col1 => { like => 23.'%' }</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22813">});</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22814"><br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22815"></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22816">I expect:</div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22842">23.33</div>12.33<div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_22845">10.33</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31063">1.33</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31071">100.33</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31072"><br></div><div><br></div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31137"><br></div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31138">I get this error when i test:</div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31139"><br></div><div id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31073" dir="ltr">$ ./test.pl<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31088">String found where operator expected at ./test.pl line 26, near "23'.%'"<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31089"> (Missing operator before '.%'?)<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31090">Possible unintended interpolation of @foo in string at ./test.pl line 29.<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31091">syntax error at ./test.pl line 26, near "23'.%'"<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31092">Global symbol "@foo" requires explicit package name (did you forget to declare "my @foo"?) at ./test.pl line 29.<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31093">Execution of ./test.pl aborted due to compilation errors.<br id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31094"></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31095"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31141"><br></div><div dir="ltr" id="yiv5505547731yui_3_16_0_ym19_1_1503077579332_31142"><br></div></div></div></div><br><br></div> </div> </div> </div></div></body></html>