If you can change the schema, the best solution would probably be to introduce two new persisted computed columns for GroupType and GroupCode, splitting up the combined field (which, I suppose, is somehow determined by some external import process). This will help with indexing as well.
On Thursday, May 28, 2015 at 7:01:25 PM UTC+2, Mark Strandness wrote: > > I have two tables "Detail" and "Group" where the link to the two is the > GROUP CODE. Problem is that the DETAIL table has the field with a single > digit to signify the type of GROUP( i.e. 'G', 'D', 'F') then the code > '0001' and the GROUP table has the linking field which is just '0001'. I > need to do a JOIN of the two tables and need to parse the "G" off and still > make the join. > Using NHibernate 4.0.0.4000 > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
